Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

if i understood right may be this

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

Anonymous
Not applicable
Author

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
Partner - Champion
Partner - Champion

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

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