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

    QlikSense how to use DrillDown master-item in Peek formula

    Tomasz Siuchniński

      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??