How to show Past and future data together

[#1]

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

[#2]

Hi,

you could use an expression like this.

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

[#3]

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.

[#4]

Any body please look into this

[tresesco]

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

[#6]

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

[tresesco]

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

[#8]

Hello Tresesco,

Thanks for the response,

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

Thanks

[tresesco]

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