Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (1)
1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Re: Set Analysis Problem

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

4 Replies
erich_shiino
Honored Contributor

Re: Set Analysis Problem

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

Re: Set Analysis Problem

HI

PFA

Not applicable

Re: Set Analysis Problem

Thanks for your help, Eric and Mayil.

Not applicable

Re: Set Analysis Problem

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

Community Browser