topic Re: How to change the value dynamically whenever select a category in QlikView

How to change the value dynamically whenever select a category

Mon, 26 May 2014 04:56:00 GMT

Hi Experts,

I would like to know how to change the values dynamically when select the List values:

Data like this:

Current_Category:

Question ID description response

112 ABC 1

113 XYZ 2

Saving_Category:

Question ID description response

115 ABC 5

118 XYZ 6

Here Question ID is different,but description is same, so user want to select the Current OR Saving then it will pick the Question ID then it will display the corresponding response values

List box like this

Re: How to change the value dynamically whenever select a category

satishkurra — Mon, 26 May 2014 05:33:06 GMT

Use the below in Dimensions and Expressions

=Alt( WildMatch( GetFieldSelections(%Dimensions, '|'), '*Country*') ,0) - Here country is the dimension

=Alt( WildMatch( GetFieldSelections( %ExpressionName, '|'), '*Total Sales*') , 0) - Here Total Sales is the Dimension with expression as SUm(Sales)

Note: The above defined Dimensions and Expression should be Enable Conditional.

Re: How to change the value dynamically whenever select a category

ashfaq_haseeb — Mon, 26 May 2014 05:50:27 GMT

Hi,

may be like this.

Regards

ASHFAQ