Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Suppose I have a straight table with three dimensions and one expression, and the expression has nested If statement along with Fractile() function.
When I select second row i.e. Test1, the value in the Metric is changing.
Our requirement is the Metric value should not change even if user selects any row in the straight table. Is there is any way, that I can get the previous value of the expression. I have tried Previous() and Only() function, but as the expression has nested If statements, the application hangs.
Waiting for inputs.
Thanks & Regards,
MK
Thanks all for the replies, please find attached the sample qvw for same.
PFA th qvw file
PFA th qvw file
Can u share ur file?
Try this
sum({$<Test1=>}Metric)
Try this formula:
=if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.1), 10,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.2), 12,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.3), 14,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.4), 16,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.5), 18,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.6), 20,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.7), 22,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.8), 24,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 0.9), 26,
if((C+B) <= fractile({<Name = , B = , C = >}TOTAL aggr((Only({<Name = , B = , C = >}C)+Only({<Name = , B = , C = >}B)),Name), 1.0), 28, 8))))))))))
Try this
=if((Only({<Name,B,C>}C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.1), 10,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.2), 12,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.3), 14,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.4), 16,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.5), 18,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.6), 20,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.7), 22,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.8), 24,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 0.9), 26,
if((Only({<Name,B,C>} C+B)) <= fractile({<Name,B,C>}TOTAL aggr((Only({<Name,B,C>} C+B)
),Name), 1.0),28,
8 ))))))))))
Thanks a lot sunindia.
It works.