Help with section access

qlikuser222 — Sat, 16 Nov 2024 00:12:13 GMT

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

Re: Help with section access

Brett_Bleess — Tue, 18 Aug 2020 18:26:47 GMT

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/SetAnalysis/set-analysis-expressions.htm

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

topic Help with section access in QlikView

Help with section access

Re: Help with section access