Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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)
Thanks for the answer!
But in the proposed version of the search - builds zeros ..
you can suppress Zero in the presentation tab.
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
There shows zeros and actually should be data zeros should not be.
If possible please attach the sample qvw.
-Nilesh
=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)
=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))
reduced data file to be smaller. See tab dinamics (CH182)