Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we use If statement and Set analysis togather???
Hi,
But your Example is purly based on if(...) condition and not on the basis of nested if condition as well as set analysis.... can you send me any examples based on set analysis and multiple if conditions ?
yojas
its nested if
yes it is nested if but without set analysis...... i want it with set analysis.....
Hi,
Sunil has a valid point.
Set analysis and Nested If can be used together.
Please find the attchaed app and see in chart how both are used together.
..
Ashutosh
see the below code
sum({<Year={'2012'}>} if(product='a',if(category=1,sale)))
nested if with set analysis.
hope this helps
What about a nested sum?
This does not work for me.
=Sum({<BandwidthandCircuit={'BandwidthandCircuit'}>}IF(sum(InBandwidth)+sum(OutBandwidth)=0,0,
IF(sum(InBandwidth)=0,sum(OutBandwidth/OutBandwidth) * 100,
IF(sum(OutBandwidth),(sum(In_Averagebps)/sum(InBandwidth)) * 100,
sum(Out_Averagebps/OutBandwidth)+sum(In_Averagebps/InBandwidth)*50))))
Hi Alex Peasley,
Basic aggregation functions can not be nested.
But, if You want to then you have to use advanced aggregation function. So, using aggr() will help you out.
To see how to use aggr(), search in community or in Qlikview manual/help also you will find details.
..
Ashutosh