Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
becki_kain
Contributor III
Contributor III

use as in a calculation but don't show as a dimension

i have data, which sales data, by vehicle by region.  i'm using region as the dimension (east, west, north, south, unknown) and i need to count all the data, in all 5 regions but i need to only show the first 4, in the final line chart.  How do you count the data but not show it?  i had done this - REGION -= {'Unk'} but i realized that is wrong, in that the values of the unknown region aren't getting counted and not being shown.  how do i get them counted but not shown?

thanks

becki kain

3 Replies
becki_kain
Contributor III
Contributor III
Author

I tried this - Re: how to hide row in pivot table, but when i suppress the null value, i lose the value that was in Unk in the total calcution

vishsaggi
Champion III
Champion III

Can you share some sample and show us exactly what output you are expecting?

delroekid
Creator
Creator

have you tried dimension limits?

first you need to sort the dimension  example sort > region > asc/desc

dimension limits > first 4 values

> show others