Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Set Context for Date Dimension

I need to have a dimension for year that has a context of "Entered" when referring to orders placed. We have two dimensions.

Fiscal Quarter

Fiscal Date Context = 'Entered'.


I need a dimension that is always Fiscal Quarter in the Entered context so the user does not need to set each individually. I was thinking of a master item but not sure how to  go about it.

The dimension should allow for the user to pick the quarter that is automatically set to 'Entered'  date context.

Thanks!

4 Replies
zebhashmi
Valued Contributor

Re: Set Context for Date Dimension

if i understood right may be this

len(Fiscal Quarter>0,'Entered') as Fiscal Date Context

danielco223
New Contributor III

Re: Set Context for Date Dimension

Hi Jahanzeb, What I would like is something like this, just not sure how to go about it.

Fiscal Quarter ({$<Fiscal Date Context = 'Entered'>}

agigliotti
Honored Contributor II

Re: Set Context for Date Dimension

to achieve what you are asking, you could create a master item dimension as below:

Aggr( Only( {< [Fiscal Date Context] = {'Entered'} >} Fiscal Quarter), [Fiscal Quarter] )

zebhashmi
Valued Contributor

Re: Set Context for Date Dimension

=replace(text(Fiscal Quarter),Fiscal Quarter,'Entered')

Community Browser