topic Variable within Variable in QlikView

Variable within Variable

Thu, 23 Jun 2011 23:32:10 GMT

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

Variable within Variable

Anonymous — Fri, 24 Jun 2011 00:17:20 GMT

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?

Variable within Variable

Fri, 24 Jun 2011 19:05:41 GMT

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

Re: Variable within Variable

Fri, 24 Jun 2011 22:06:20 GMT

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