Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Limit the dimension values in pivot table

Hello All,

I need to show the sales value by CustomerGrp, CustomerName and by agency in a pivot table.

I have around 100+ CustomerGroup and agency and i want to show the sales value only for the selected CustomerGroup and selected Agency.

Any idea how we can achieve the same.

how about creating the calculated dimension like if(match(CustomerGroup, 'Group1', 'Group2')) as CustomerGroup.

Thanks for the suggestion.



1 Reply

Hi Viresh,

There are couple of ways to do this.

1. Using If statement in dimension (Similar to what you have shown).

2. Adding set analysis and filtering the data.

3. Create a separate field in script to have only required group and then using it as dimension with Suppress null option.


Kaushik Solanki

If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".