topic Re: Set Analysis in QlikView

Set Analysis

Thu, 06 Feb 2014 14:38:07 GMT

Hi all

I have a script with one fact table and two dimension tables.

One of the dimension tables is a calendar with each calendar date in it, which includes various groupings like Year, Week, YTD, QTD, LastWeek, LastMonth etc.

On most of the sheets in my report I want the figures to be sliced and diced by the various date selections, however on one sheet I want the data to be sliced by the fields in the other dimension table only.

I am using set analysis, but rather than ask the formula to ignore each calendar field seperately in something like the following

=Sum({$<YTD=, ThisWeek=, ThisMonth=>}FactValue)

Is there a way to use set analysis to ignore all field selections except the ones that I specify? I know you can use 1 as the identifier, but how then do I ask the expression to honour the selection in a field like 'Depot'

=Sum({1<Depot={[Selection]}, ReportGroup={[Selection]}>}FactValue)

Thanks

James

Re: Set Analysis

Anonymous — Thu, 06 Feb 2014 14:40:30 GMT

James,

Try this:

=Sum({1<Depot=P(Depot), ReportGroup=P(ReportGroup)>}FactValue)

Re: Set Analysis

jonathandienst — Thu, 06 Feb 2014 14:44:51 GMT

Or try this:

http://community.qlik.com/message/1267#1267

Re: Set Analysis

ThornOfCrowns — Thu, 06 Feb 2014 14:47:49 GMT

What does the P do in P(Depot)?

Re: Set Analysis

Anonymous — Thu, 06 Feb 2014 14:49:15 GMT

P stands for possible.

Depot will be using possible values of itself.

Re: Set Analysis

ThornOfCrowns — Thu, 06 Feb 2014 14:50:36 GMT

Ah, I see. Many Thanks!