topic Re: How to show Past and future data together in QlikView

How to show Past and future data together

Thu, 30 Oct 2014 13:41:42 GMT

Hello Everyone,

I have DATE field, and two measures

i wanted to show past data and future data together, means if select 2014 till today it should show measure1 value, from tomorrow is should show measure2 value.

i tried with Today()>DATE condition, but not working,

can anybody please tell me, how to do this.

Thanks

Re: How to show Past and future data together

Thu, 30 Oct 2014 14:16:39 GMT

Hi,

you could use an expression like this.

if(sum({<Date={'$(=Date(Today()))'}>}Sale1)=NULL(),sum(Sale2)).

Re: How to show Past and future data together

Thu, 30 Oct 2014 15:12:59 GMT

Hello Shruthi,

Thanks for the response

its not working,

i am using like if(Date(Today(),'MM/DD/YYYY')<Max(Date), measure1, measure2).

in Max(DATE) should not change based on the selection, it should always one date, which can show the value always greater than today, i cant use DATE directly, because user will select only month and year, if i use date there it gives us multiple dates.

Re: How to show Past and future data together

Fri, 31 Oct 2014 04:48:10 GMT

Any body please look into this

Re: How to show Past and future data together

tresB — Fri, 31 Oct 2014 05:00:02 GMT

Could you create a sample qvw and share explaining the expected output?

Re: Re: How to show Past and future data together

Fri, 31 Oct 2014 06:35:49 GMT

Hello tresesco,

Please look into the attached Qvw and Excel, Here i wanted to show the past and future in the same chart, i should put the condition based on the DATE, not the month.

If DATE<Today() like that

Please help

Re: Re: Re: How to show Past and future data together

tresB — Fri, 31 Oct 2014 06:45:24 GMT

May be like:

=sum(if( Date<Today(), [Source2-1.Source2.Revenue]))

=sum(if( Date>=Today(), [Source2-1.Source2.Revenue]))

The similar could be done using set analysis as well.

PFA

Re: How to show Past and future data together

Fri, 31 Oct 2014 07:12:48 GMT

Hello Tresesco,

Thanks for the response,

But i wanted to show both sources together in the chart. Not in the different bars.

Thanks

Re: How to show Past and future data together

tresB — Fri, 31 Oct 2014 07:17:37 GMT

Stacked? Goto Style tab->Subtype->check stacked