topic Re: filter condition in QlikView

filter condition

raadwiptec — Thu, 17 Dec 2015 12:52:45 GMT

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

Re: filter condition

Anonymous — Thu, 17 Dec 2015 12:57:47 GMT

For your product dimension tick the Show All Values option.

Re: filter condition

VishalWaghole — Thu, 17 Dec 2015 13:01:09 GMT

Hi,

Go to presentation tab, and try this...

Re: filter condition

settu_periasamy — Thu, 17 Dec 2015 13:06:54 GMT

Hi,

Dimensions Tab -> Check Show All Values

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

Re: filter condition

raadwiptec — Thu, 17 Dec 2015 13:26:20 GMT

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

Re: filter condition

Thu, 17 Dec 2015 13:28:30 GMT

Hi,

Can you please share your QVW file please?

HTH-KC

Re: filter condition

VishalWaghole — Fri, 18 Dec 2015 07:06:13 GMT

Hi, Can you please share dummy data if possible.

Re: filter condition

raadwiptec — Fri, 18 Dec 2015 08:13:51 GMT

Hi Please find the dummy data with qvw

Re: filter condition

settu_periasamy — Fri, 18 Dec 2015 09:42:15 GMT

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.