Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 

Use Variables Values as Dimensions

Hi experts,

I'm new to Qlik, I have read several post concerning the problem and tried most of them, but still I can't figure out why this formula it's not working.

=if(num(aggr(sum(if(upper(Measure_type)=vMisura3  and ($(v_test3) =text(v_test4)),Value,0)),$(v_test1)))>num($(v_test2)),'Yes','No')

The problem is concerning the bold part.

I have created two variables:

v_test3 has as static values the names of different dimension (Client,Function)

v_test4 has the possible values that the two dimensions contain (e.g.  Nike, Adidas,etc. for the Client)

I then added 2 input boxes in which the user have to select the values for v_test3 and v_test4.

Trying to explain better I would like to have $(v_test3) =(v_test4) to be like Client = 'Nike'  where client is the dimension and Nike is the value he has to look for.

Is it possible to do it? Thanks in advance for your help!

Labels (2)
0 Replies