Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Problem

Hi experts,

I have been facing a problem in using set analysis for one my set analysis.

Selections available for users: Year, Quarter, Month, Week, Region, Country

What I would like to calculate? - Cost for current week i.e. Maximum week for a particular region or country. I do not want the selections made by the user in Year, Quarter, Month and Week to have any effect on this.

Formula used:     sum({$<Year=,Quarter=,Month=,Week={$(=Max(Week))}>}Cost)

Somehow, this is not negating the selection made by user in Quarter or Month or Week.

Please find the example file I created for reference.

Any help would be appreciated!

Thanks,

Kiran

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

Hi,

You can apply set analysis to your Max(Week) as well...

=sum({$<Year=,Quarter=,Month=,Week={$(=Max({<Year=,Quarter=,Month=>}Week))}>}Cost)

Regards,

Erich

View solution in original post

4 Replies
erichshiino
Partner - Master
Partner - Master

Hi,

You can apply set analysis to your Max(Week) as well...

=sum({$<Year=,Quarter=,Month=,Week={$(=Max({<Year=,Quarter=,Month=>}Week))}>}Cost)

Regards,

Erich

MayilVahanan

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks for your help, Eric and Mayil.

Not applicable
Author

hello friend,

i really intenses to learn this qlikview will u tell me how to learn there i get doc's for this and software and all