Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am new to qlikview and need your help.
I need make a chart for returned sales.
The condition is closed date - opened date less than 20 days.
How would i do it in set analysis?
Please help me
Thanks & Regards,
Jaya
May be this?
Sum(If(([closed date]-[opened date])<20,[returned sales]))
OR
If(([closed date]-[opened date])<20, 1,0) as Flag
Expression is this?
Sum({<Flag = {1}>} [returned sales])