12 Replies Latest reply: Jan 23, 2014 2:39 AM by Anton sineok

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.

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.

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

• ###### Re: Ask two filters simultaneously.

you can suppress Zero in the presentation tab.

• ###### Re: Ask two filters simultaneously.

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

• ###### Re: Ask two filters simultaneously.

If possible please attach the sample qvw.

-Nilesh

• ###### Re: Re: Ask two filters simultaneously.

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

• ###### Re: Ask two filters simultaneously.

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: Re: Ask two filters simultaneously.

Thank you. But shows dashes

• ###### Re: Ask two filters simultaneously.

=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.

=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.

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

• ###### Re: Re: Ask two filters simultaneously.

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