Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

filter condition

Hi all,

This is my scenario. its  a pivot table

               country -       USA           UK            CHI        ESP           CSB         KOL

product         

bulbs

capacitora

thermos

m120

c480p

therb90

basically all the products has to be shown but I  need to limit the countries only to UK and USA. My problem is if I apply an filter on the countries .. certain product gets removed. I would like to keep the product as well and show that it is 0.

               country -       USA           UK        

product                       0                   0

bulbs                           100             10

capacitora                    0                 10

thermos

m120

c480p

therb90

8 Replies
Anonymous
Not applicable

For your product dimension tick the Show All Values option.

VishalWaghole
Specialist II
Specialist II

Hi,

Go to presentation tab, and try this...

Capture1.JPG

settu_periasamy
Master III
Master III

Hi,

Dimensions Tab -> Check Show All Values

Presentation Tab -> Uncheck Suppress Zero-Values ,Null Symbol -> 0 and Missing Symbol -> 0

raadwiptec
Creator II
Creator II
Author

no its not working. basically iam using a match condition to filter the countries while loading.. is their any other way to filter?

Not applicable

Hi,

Can you please share your QVW file please?

HTH-KC

VishalWaghole
Specialist II
Specialist II

Hi, Can you please share dummy data if possible.

raadwiptec
Creator II
Creator II
Author

Hi Please find the dummy data with qvw

settu_periasamy
Master III
Master III

Hi,

you can load all your data without limit in the script. you can restrict it in front end using set analysis

check the attachment. may be helps.