Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with section access

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

 

Labels (3)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.