Qlik Community

Community Corner

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

This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
New Contributor II

Adding a new dimension value using set analysis


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
Valued Contributor

Re: Adding a new dimension value using set analysis



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

Community Browser