topic Linking listbox to Calculated dimension in QlikView

Linking listbox to Calculated dimension

Sun, 11 Sep 2011 15:21:50 GMT

Hi,

I am new to QlikView and have run into a problem. I would appreciate it very much if someone could guide me to a solution.

I have a calculated dimension, say CD, in a pivot table.

This calculated dimension is dependent on the value of a slider.

I need to link CD to a list box so that the user can filter the records in the pivot table.

I using the same CD in the listbox but have not been able to get the result.

Again, I would be extremely thankful if someone could help me.

Thanks in advance,

Gary

Linking listbox to Calculated dimension

SunilChauhan — Sun, 11 Sep 2011 17:30:40 GMT

i am not understanding clearly

but hope below help

take a list box and write same expression as CD in list box

Linking listbox to Calculated dimension

jonathandienst — Sun, 11 Sep 2011 18:06:28 GMT

Hi Gary

If Sunil's suggestion does not work, then I suggest that you post your model, or a sample of it.

Regards

Jonathan

Re: Linking listbox to Calculated dimension

Mon, 12 Sep 2011 05:53:50 GMT

Below is attached a sample of what I am trying to achieve.

As you will see, the listbox does not work.

Regards,

Gary

Re: Linking listbox to Calculated dimension

s_uhlig — Mon, 12 Sep 2011 09:13:08 GMT

Hi garymokha,

you can use

=aggr(if(MARKS/100<=THRESHOLD,'PASS','FAIL'),MARKS)

as the listbox-expression and qlikview will select the corresponding records.

Regards

Sven

garymokha

Re: Linking listbox to Calculated dimension

Mon, 12 Sep 2011 09:28:14 GMT

Hi S.Uhlig,

I have another question, what if instead of MARKS, I had something like this in the IF condition:

if(PRODA_SALES/TOTAL_SALES>=THRESHOLD,'A',

IF(PRODB_SALES/TOTAL_SALES>=THRESHOLD,'B','NEITHER'))

what would I use as dimension in the AGGR function?

Btw, your suggested method worked perfectly for the sample I posted, but I have a more complex requirement as well (as posted in this post). Would be grateful if you could suggest a solution for this.

Thanks,

Gary

Re: Linking listbox to Calculated dimension

s_uhlig — Mon, 12 Sep 2011 22:45:09 GMT

Hi Gary,

of course, it depends highly on our model and therefore the only suggestion I can give, is that qlikview does the selection based on the aggr dimensions.

Imagine a table like

LOAD * INLINE [
    id, a, b
    1, 2, 5
    2, 3, 4
    3, 4, 3
    4, 5, 2
    5, 5, 5
];

now you want a selection where a+b<10. You can do something like aggr(a+b<10,a,b), which selects a=[2..5] and b=[2..5] when you press true (-1) in your listbox.

This could be okay, but in our situation we don't want the combination a=5 and b=5. As you can see, we have to rely on column id, because it's reflects the relation between a and b. With the expression aggr(a+b<10,id) we accomplished the desired behavior.

Nice? Maybe we don't want to expose our technical key id to the ui, but now it appears whithin the current selections - okay we are back at step 1 - it depends on your model and what you want to do with it.

Regards,

Sven