3 Replies Latest reply: Nov 8, 2016 12:43 PM by Shahbaz Khan Mohammed

Set Analysis applied to a dimension

Giuseppe De Vivo Nov 8, 2016 11:26 AM

Hi all,

I'm trying to calculate a dimension column with this expression:

$(=Only( {$<dimension1={'$(vVarCase)'}> + <dimension1={'1'}> } dimension1))

Dimension1 has only '0' or '1' values and I need to obtain 2 different case:

1) To show only '1' value

2) To show both value '1' and '0'

How do the user can choose the case?

He has a select box with 2 value "OFF" = 0 and 'ON' = 1.

The select box is linked to a varaiable 'vVarCase' that is '0' or '1'.

When the user chooses ON then, I need to show che case number 1, if he chooses OFF I need to show the case 2.

I tryed to apply set analysis to my dimension, but it doesn't work.

Can somone help me, please?

Thank you in advance.

Re: Set Analysis applied to a dimension

Sunny Talwar Nov 8, 2016 11:48 AM (in response to Giuseppe De Vivo)

Not sure I understand the complete setup, would you be able to provide a sample to look at with the expected output?
Like Show 0 Likes (0)

Actions
Re: Set Analysis applied to a dimension

Shahbaz Khan Mohammed Nov 8, 2016 12:37 PM (in response to Giuseppe De Vivo)

To my knowledge, Qlik Sense doesn't support calculated dimensions.
It only takes a field as dimension, try using same expression in your expression window.
Like Show 0 Likes (0)

Actions
Re: Set Analysis applied to a dimension

Shahbaz Khan Mohammed Nov 8, 2016 12:43 PM (in response to Giuseppe De Vivo)
Find the attachment for Qlik Ad-Hoc example.
It is an extension (download it separately from Qlik Branch) but you can use this ON/OFF button, link it to an Object or Sheet ID.
Add your set expression to Master Items in measures, you'll have ON/OFF button available.
BTW, I do not know if your expression is correct or no. Experts here can help you with that but I'm quite sure about Calculated Dimension to not work in Sense.

Quick AdHoc Example.qvf 416.0 K
Like Show 0 Likes (0)

Actions