Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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')