Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
HI
PFA
Thanks for your help, Eric and Mayil.
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