3 Replies Latest reply: Dec 29, 2015 2:22 PM by Sangram Reddy

# QlikSense how to use DrillDown master-item in Peek formula

Hello,

How to point Master-item drill down dimension in Peek() formula?

I have few time grain standard dimensions: Year (named 'YearDim'), Quarter ('QuarterDim'), Month(MonthDim).

I also created Y>Q>M drill-down master-item dimension called ('YQMDim').

I have variable called vTimeGrain which I'm using do change time dimension of my chart.

Chart has dimension defined by formula:

Pick(Match('\$(vTimeGrain)','YYYY','QQ','MM'),YearDim,QuarterDim,MonthDim)

It works fine when I'm using 'standard' dimensions, so when vTimeGrain equals 'YYYY' - chart uses 'YearDim', when vTimeGrain equals 'MM' chart uses 'YearDim' and so on.

When I'm trying to point drill-down dimension 'YQMDim' in my formula, dimension is not changing

Pick(Match('\$(vTimeGrain)','YYYY','QQ','MM','YQM'),YearDim,QuarterDim,MonthDim,'YQMDim')

It selects YearDim, QuarterDim, MonthDim but not YQMDim

Is it possible to use drill-down master-item in such a formula????

Is there special notation for calling master-items??

• ###### Re: QlikSense how to use DrillDown master-item in Peek formula

Hi Tomasz,

Master Items cannot be made use of in the expression editor and hence you cannot refer to them. A drill down master dimension acts a dimension itself and this cannot be used in the pick statement. This is the reason why you are not able to refer to it.

The master Items being derived dimensions and measures are calculated during the runtime only. They do not reside physically like the date field. And I would not say that this is a limitation as its totally possible if you develop a custom visualisation and implement the functionality you mentioned.

Thanks,

Sangram.

• ###### Re: QlikSense how to use DrillDown master-item in Peek formula

Hi, Sangram

Unfortunately, I expected such a response. However I wanted to check that I realy cannot refer to master-item dimension in such a formula.

Thanks. Tomek

• ###### Re: QlikSense how to use DrillDown master-item in Peek formula

Hi Tomasz,

Though its not possible implicitly, you can create an extension to achieve this.

Thanks,

Sangram Reddy.