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(…)
Hello, Today, I’ll show you a clever technique to calculate the user defined time intervals. I’ll use the expression instead of field for calculated dimension. I have learnt this technique fromRob Wunderlich on QlikView Community. So all credit to him for sharing this technique. Here is the expression of the calculated dimension and I’m sorry I(…)
Hello, Today I’ll show you how to use Match() function in QlikView. This is one of my favourite functions in QlikView. 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(…)
Hello, Today I’ll show you how to hightlight specific dimension label on bar chart. You can highlight the highest or the lowest values for the dimension. I have used Only() function to get this working. I have learnt this technique from Vlad Gutkovsky on QlikView Community. So all credit to him for sharing this technique. I’ll demonstrate(…)
Hello, Today I’ll show you how to highlight the minimum & maximum values on a line chart. This is very useful technique to show the lowest & highest values on the line chart. To get this working, I’ll use multiple expressions with a single dimension. I have also used Rank() & IF statement. I’m also(…)
Hello, Today I’ll show you how to extract Dimension/Field name from the calculated dimension in QlikView. I’ll also introduce calculated dimensions and subfield() function in QlikView. This is just brief overview of calculated dimensions. In future videos I’ll cover the calculated dimensions in detail. I have learnt this technique from NMiller (Community User) from QlikView Community. So(…)
This short video demonstrates on how to load colours within the QlikView Script. You can use this technique to save time and maintain peristent colours. I have used this approach in RAD (Rapid Application Development). I’ll cover more advanced use of this technique in future videos. Thank you for watching. Happy learning.