Help with section access

[qlikuser222]

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

[Brett_Bleess · Accepted solution]

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:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

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