Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we use If statement and Set analysis togather???
yes you can see the example application
see the attached file
see expression of bar charts
hope this helps
Yes, you can and there are scenarios where this is a usual setting.
edit: I assumed you mean using if() and set analysis within an aggregation function...
yea we can like below
sum({<Year={'2010'}>} if(Month='Jan' ,Sales))
hope this helps
please can you give me any example on that ehere therre is a combination of if and set analysis......its very imp to know me.....
hi sunil
are you sure the expression you used is correct???
please can you send me any type of sample application in which such type of condition is working???
yes you can see the example application
see the attached file
see expression of bar charts
hope this helps
Thanks for sending me that sample.......
Hi sunil,
In your example you successfully implemented set analysis with 1 if statement.... but is it possible to implement nested if condition in set analysis? I tried it in your example but it is not working .....can you give me some information on this???
yojas
yes we can do like below
sum(if(Year=2012,if(product='a',sale))