Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the value dynamically whenever select a category

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

Category

Current_category

Saving_category


when we will select on current category or saving category then it will hit to the Question ID and need to display that Response values


Thanks in Advance

2 Replies
satishkurra
Specialist II
Specialist II

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

may be like this.

Regards

ASHFAQ