May
11

FirstSortedValue function in QlikView – Part II

Hello,

Good morning. This is the second part of two part series on FirstSortedValue function. I’d recommend you to watch the first part before watching this video. In this video, I’ll talk about practical scenarios on where we can use FirstSortedValue function. I have demonstrated step-by-step process.

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube.

Thank you for watching. Happy learning.

1 vote, 5.00 avg. rating (98% score)

May
07

FirstSortedValue function in QlikView – Part I

Hello

Today, let’s talk about FirstSortedValue function in QlikView. This function can be used as both chart expression and script expression. However in this tutorial, I’m going to focus on using it as chart expression. I have divided this tutorial in two parts and this first part of two part series. In this part, I’ll cover detailed explanation about FirstSortedValue function and then I have covered Local Expression Processing of FirstSortedValue function. And this in the next part I have covered detailed examples on how to use FirstSortedValue function.

I have demonstrated step-by-step process. I personally enjoy the challenge to push the limits and I hope you have enjoyed it as well.

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube.

Thank you for watching. Happy learning.

3 votes, 5.00 avg. rating (99% score)

Apr
27

QlikView Dimension as URL/Link

Hello,

Welcome back to QlikShare.Com. I wanted to thank you for visiting my blog. Few days back one of the member on QlikView Community (Geetha) asked an interesting question – How to set up Dimension as URL?

I’m sure most of you know that you can setup Expression as URL by using Representation property on the expression tab. However, I have realised that there is no property for Chart Dimension. So I have decided to play with Chart Properties to see if I can achieve this one. Finally, I have got it working but this is not 100% clean workaround. But you can still use this chart, if you have an absolute requirement to setup Dimension as URL/Link.

I have demonstrated step-by-step process on how to get this working. I personally enjoy the challenge to push the limits and I hope you have enjoyed it as well.

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube.

Thank you for watching. Happy learning.

Cheers – DV

 

2 votes, 5.00 avg. rating (98% score)

Apr
25

Partial Reload in QlikView – Part II

Hello,

Welcome back. This video is second part of two part series on Partial Reload. If you have not seen the first part then I’d recommend you to go watch the first part for full understanding. Please click here to access the first part. Partial Reload is executed on the current script including all script commands, such as drop tables and drop fields. However, loading tables by using Load & Select statements must be preceded by ADD and REPLACE prefix. I have divided this topic into two videos. In the second post, I’ll cover :

  • Replace Prefix
  • IsPartialRelaod() Function
  • Advanced Scripting with Partial Reload

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy learning.

0 votes, 0.00 avg. rating (0% score)

Apr
21

Partial Reload in QlikView – Part I

Hello,

Today, I’ll talk about Partial Reload in QlikView. Partial Reload is executed on the current script including all script commands, such as drop tables and drop fields. However, loading tables by using Load & Select statements must be preceded by ADD and REPLACE prefix. I have divided this topic into two videos. In the first post, I’ll cover :

  • What is Partial Reload?
  • Add Prefix
  • Exists Function
  • Only Qualifier

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy learning.

3 votes, 4.67 avg. rating (94% score)

Apr
19

Cricket World Cup Analysis in QlikView – Part 3 (Final Part)

Hello,

Welcome back! This video is third part of three part series on Cricket World Cup Analysis in QlikView. Please click here to access first part and second part.

I’ll demonstrate step-by-step process. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.

1 vote, 5.00 avg. rating (98% score)

Apr
17

Cricket World Cup Analysis in QlikView – Part 2

Hello,

Welcome back! This video is part two of three part series on Cricket World Cup Analysis in QlikView. Please click here to watch the first part of this tutorial.

I’ll demonstrate step-by-step process. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.

1 vote, 5.00 avg. rating (98% score)

Apr
13

Cricket World Cup Analysis in QlikView – Part 1

Hello,

Today I’m going to show you interesting stuff in QlikView. This is advanced topic (Level-III) and I’d assume that you already know how to create charts, modify their properties and use variables. I am going to divide this topic into three parts to keep the videos short. This technique opens new ideas and show the power of QlikView. Most important aspect to remember is the configuration of individual charts for effective and powerful output. Please go through all the parts in this series for full understanding.

I’ll demonstrate step-by-step process. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.

2 votes, 5.00 avg. rating (98% score)

Feb
26

Set Offset Value to Bar Chart in QlikView

Hello,

Today, I’ll show you clever technique on how to setup the offset for the bar chart. I have followed four step process. I’ll demonstrate step-by-step process. Please contact me if you have any questions.

Just in case if you can’t watch the video from this site, you can use this link to watch from Youtube.

Thank you for watching. Happy learning.

3 votes, 5.00 avg. rating (99% score)

Feb
24

Attribute Chart Expressions in QlikView

Hello,

Today, I’ll talk about attribute chart expressions in QlikView. These attributes are hidden and may not be obvious. You can see these attributes only when you click on the “+” sign in front of the expression. We have 7 different attributes and some of them are only applicable to specific chart types.

  • Background colour
  • Text Colour
  • Text Format
  • Pie Popout
  • Bar Offset
  • Line Style
  • Show Value

These attributes are very useful and can be powerful way to customize the formatting within QlikView Chart Objects.

Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy learning.

4 votes, 5.00 avg. rating (99% score)

Older posts «

Social Widgets powered by AB-WebLog.com.

Follow

Get every new post on this blog delivered to your Inbox.

Join other followers: