topic Re: Ask two filters simultaneously. in QlikView

Ask two filters simultaneously.

antonrus — Thu, 16 Jan 2014 11:57:12 GMT

Ask two filters simultaneously.

Hello!

(sorry I do not speak in English )

Try to set two filters at the same time , only one works . The situation is perhaps complicated by the fact that the report needed to compare data for different time periods (years) .

first filter :

sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } if (Day = DAYIsland, QUANTITY))

- Working correctly.

but if I add it to the second filter , output, over the past year - the filter does not work on the dishes - as if it is not.

sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } {<Year={"$(vPrevYear)"}>} if (Day = DAYIsland, QUANTITY))

For several days, I can not understand how to solve it . Thanks in advance !

Re: Ask two filters simultaneously.

jvishnuram — Thu, 16 Jan 2014 12:07:29 GMT

Hi Ahtoh,

why you want to use the if condition., that also get it done by the set analysis.,

sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'}> } {<Year={"$(vPrevYear)"},Day={'DAYIsland'}>} QUANTITY)

Re: Ask two filters simultaneously.

antonrus — Thu, 16 Jan 2014 12:23:43 GMT

Thanks for the answer!

But in the proposed version of the search - builds zeros ..

Re: Ask two filters simultaneously.

nilesh_gangurde — Thu, 16 Jan 2014 12:47:47 GMT

you can suppress Zero in the presentation tab.

Re: Ask two filters simultaneously.

kiranmanoharrode — Thu, 16 Jan 2014 12:51:29 GMT

Dear Ahtok,

try below Expression

=sum ({ <CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={"$(vPrevYear)"},Day = (DAYIsland)>},QUANTITY))

Regards

Kiran Rode

+91 8976977897

Re: Ask two filters simultaneously.

antonrus — Thu, 16 Jan 2014 12:51:48 GMT

There shows zeros and actually should be data zeros should not be.

Re: Ask two filters simultaneously.

nilesh_gangurde — Thu, 16 Jan 2014 12:53:45 GMT

If possible please attach the sample qvw.

-Nilesh

Re: Ask two filters simultaneously.

nizamsha — Thu, 16 Jan 2014 13:26:32 GMT

=sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={"$(=Max(Year)-1)"},Day={'DAYIsland'}>}Amount)

Or this one

=sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={'$(vPrevYear)'},Day={'DAYIsland'}>}Amount)

Re: Ask two filters simultaneously.

nizamsha — Thu, 16 Jan 2014 13:37:07 GMT

=sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={"$(=Max(Year)-1)"},Day={'DAYIsland'}>}Amount)

Or this one

=sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={'$(vPrevYear)'},Day={'DAYIsland'}>}Amount)

Based on Selection u want current year and last year mean

=if(Year= Max(Year),sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Day={'DAYIsland'}>}Amount),

sum({$<CATEGORY_RU={'Sendvichi 15sm','Sendvichi 30sm','Salaty','Rolly','Beybi Saby','Sneki'},Year={"$(=Max(Year)-1)"},Day={'DAYIsland'}>}Amount))

Re: Re: Ask two filters simultaneously.

antonrus — Fri, 17 Jan 2014 07:30:11 GMT

reduced data file to be smaller. See tab dinamics (CH182)

Re: Re: Ask two filters simultaneously.

antonrus — Fri, 17 Jan 2014 08:09:08 GMT

Thank you. Tried all options - but does not believe. (shows or zeros or dashes)

Re: Re: Ask two filters simultaneously.

antonrus — Fri, 17 Jan 2014 08:55:49 GMT

Thank you. But shows dashes

Re: Re: Ask two filters simultaneously.

antonrus — Thu, 23 Jan 2014 07:39:07 GMT

Does not work to use two filters .. can someone that is working examples please ..