Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III
‎2018-01-25 08:23 AM

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,140 Views
0 Likes
1 Reply
kaushiknsolanki
MVP
MVP
‎2018-01-25 08:29 AM

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".
932 Views
0 Likes