Advanced variable operations in QlikView

Подписаться 69 тыс.

Просмотров 29 тыс.

50% 1

Variables usage is one of the very important topics in QlikView to achieve the desired behavior. There is lot of magic that we can achieve by efficiently using the variables.
In this second video, I've taken a deep dive into few more important variables usages and explained the topic with the help of an example.
I hope you will find this video useful and an addition to your existing learning of QlikView.
-Abhishek

Опубликовано:

6 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@GaryHutsonVBA 4 года назад

Nice explanation. More familiar with Qlik Sense, but this is a great example of how to use in Qlik View.

@earlGaburu542 8 лет назад

Hi abhishek, thanks for the video i have question, how to use variables with strings. like i have big bar chart of train name and service num with one expression now requirement is, user will give train name in input box then bar chart will fetch the data of particular train name its service num and sum of passengers

@AbhishekAgarrwal 8 лет назад

+Vinod Raghu Looking at your requirement, I think "Search Object" will be a better option than achieving the similar functionality with Variable and Input Box object. But if you want to achieve it by variable only, then you need to specify the variable within the set analysis of your expressions.

@bellashirota 8 лет назад

Hi thanks for the video. simple yet helpful. I have 1 question, let say I extract the data from the database. I want to display certain value in the textbox. for example when we click class A button, the texbox will display total male student and total female student in class A. same goes to class B button and so on. how to enable the textbox to change its value based on the button selection ? TQ in advanced

@AbhishekAgarrwal 8 лет назад

+Bella Shirota Glad to know videos are helpful to you. Regarding your scenario, you can achieve it by utilizing triggers with if condition. Basic idea is that use triggers to enable the button of your choice, pass the enabled button value to if condition within expression that is present in text box and accordingly your result will be updated in text box. Hope it helps.

@bregeenc 8 лет назад

Hello! You're videos are very informative - thank you! One question - i have followed your steps to change the currency symbol to Euro. When i do this - the numeric values change but the £ sign is still showing when i select Euro. Do you know what the reason could be for this. Thanks Bregeen

@AbhishekAgarrwal 8 лет назад

Yeah, it is because we have not applied the formatting of numbers. Probably you can wrap the outcome expression in the text function to format it in the desired currency code.

@bregeenc 8 лет назад

Would you have an example of that? I'm very new to expressions! Thank You in advance

@AbhishekAgarrwal 8 лет назад

Sure, please see the below syntax. If(var=EUR, Num(Sum([Field]),'€#,##0'),Num(Sum([Field]),'$#,##0')) It is basically saying that if the var value is EUR then format the sum function value with the specified EURO currency format and for rest of the other values, format the sum function outcome into USD.