Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
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.

Regards,

Viresh

1 Reply
kaushiknsolanki

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.

Regards,

Kaushik Solanki

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