topic Setting Variables using functions. in QlikView

Setting Variables using functions.

Fri, 11 May 2012 18:36:42 GMT

Please help me with the following requirement. Or please direct me to the right resources. ( I am new to QV).

- I have a button in a dashboard. Upon clicking that button, it should trigger some action, which will set the Value for a variable.

Description: I will provide 4 buttons. Clicking on each button will set the value of the variable ( say varDimName ) to some specific Value. Based on that value, I want to decide the dimension in a chart. So, as the user clicks on each of the buttons, the dimensions in the chart changes and the chart appears to cycle through the dimensions. ( I dont want to use the Cyclic Group ).

Regards.

Re: Setting Variables using functions.

erichshiino — Fri, 11 May 2012 19:25:53 GMT

Hi,

You can config the buttons to set the variables using actions:

Button properties -> Actions -> External -> Set Variable

There, you set varDimName to the names you need.

In the chart, you just need to include a calculated dimension with the following syntax:

$(varDimName)

There is an example attached in this post

Regards,

Erich

Setting Variables using functions.

Fri, 11 May 2012 20:21:01 GMT

Create a variable vDimName. To First button, add action as

Action-> Set Variable-> Variable: vDimName-> Value : A

similarly

Action-> Set Variable-> Variable: vDimName-> Value : B

Action-> Set Variable-> Variable: vDimName-> Value : C

Action-> Set Variable-> Variable: vDimName-> Value : D for other 3 buttons

for the first dimensions in the chart add ENABLE CONDITIONAL as vDimName= 'A' similarly vDimName= 'B', vDimName= 'C', vDimName= 'D' for the remaining 3 Dimensions respectively.

Hope that helps

Regards,