Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Can anyone please help me with set analysis for below requirement.
Date, Data
Jan 2020, $100
Feb 2020, $100
Mar 2020, $150
Apr 2020, null
May 2020, null
Above is my example data and I'm trying to present field Data in a text box like when nothing is selected it should give me Avg (i.e 116.6)and if i select Apr 2020 it should give me previous month where field Data is not null (i.e Mar 2020 = $150) and same with Jun 2020 it should give me give me previous month where Data is not null (i.e Mar 2020 = $150) .
Please help
Thanks All
Little confused by the subject of this one, you may want to update that, as that may be why folks have not looked at things. About the best I can offer are some Design Blog and Help links for you, as I am not very good at Set Analysis either, but hopefully the link may help you get it sorted.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
There are some sub topic links at the bottom of that one, just FYI...
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Help link:
Sorry I do not have anything better, but potentially my commenting may get someone else to read things, and they may have some other ideas for you, but again, would update the subject if you can, as Help with section access is definitely not related to Set Analysis! 🙂
Regards,
Brett
Little confused by the subject of this one, you may want to update that, as that may be why folks have not looked at things. About the best I can offer are some Design Blog and Help links for you, as I am not very good at Set Analysis either, but hopefully the link may help you get it sorted.
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
There are some sub topic links at the bottom of that one, just FYI...
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Help link:
Sorry I do not have anything better, but potentially my commenting may get someone else to read things, and they may have some other ideas for you, but again, would update the subject if you can, as Help with section access is definitely not related to Set Analysis! 🙂
Regards,
Brett