Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Variable within Variable

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

Variable within Variable

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

Re: Variable within Variable

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