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: 
Not applicable

Variable within Variable

Hi Everyone,

I have three fields Qtr Desc(Quarter Description), Date & Created Date.

So, when I pick 2011 Q4 in Qtr Desc it selects a date range 1/2/2011 to 03/28/2011.For the same date range I want all

the items created in this date range.

So how do I do this.

Please help,

Regards,

Bikash

3 Replies
Anonymous
Not applicable
Author

Hi Bikash,

I assume the Created Date is in another table than the Date? Otherwise you should be able to just add the field Created Date to your layout.

If you have a proper connection between the tables it should work just fine. Are you connecting on the Date field?

Not applicable
Author

Yes Johannes,

They are in separate tables. Created date is from the fact table called Opportunity and the Fiscal Year and Qtr Desc are from Time dimension table - Time.

Could you please suggest how can I achieve this?

Thanks & Regards,

Bikash

Not applicable
Author

Hi,

This is how my Data Model looks like.
I want to connect CREATED_DATE and the Time Table by some way.

Thanks in advance,

regards,

Bikash