Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
you could use an expression like this.
if(sum({<Date={'$(=Date(Today()))'}>}Sale1)=NULL(),sum(Sale2)).
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.
Any body please look into this
Could you create a sample qvw and share explaining the expected output?
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
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
Hello Tresesco,
Thanks for the response,
But i wanted to show both sources together in the chart. Not in the different bars.
Thanks
Stacked? Goto Style tab->Subtype->check stacked