Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Highlighted
sai_katare
New Contributor II

Adding a new dimension value using set analysis

 Hi,

I have a list box (attached). 

The filter has to be single selection (as we are using the filter values to pass through URL and can only take one dimension value not multiple). 

Now the requirement is to have another dimension value as 'ALL' in this filter selecting which the user has data pertaining to other 3 dimension values in pivot table.

Question - Can we achieve this using Set Analysis? I mean can I create another column which includes 'ALL' and remaining dimension values of [Fault Level]. If yes, please help me with the formula. Or give a fair idea about how to achieve this. 

Labels (3)
1 Reply
anushree1
Contributor II

Re: Adding a new dimension value using set analysis

 

Hi,

Please check the attachment, is this what you are looking for?

Community Browser