Set Analysis for Current day & Multi Date Range

[#1]

HI All,

I am trying to create City sales contribution  in  a pie chart for current day (as default display  ) & on selection basis of date range pie chart should change to particular date selection is it possible in set analysis. @ !

[#2]

ho to want to change the date. means by input calendar or select from list box

sum({$<date={"some date"}>}sales)

[neelamsaroha157]

One sol'n that I can think of is ..you can set a trigger to select the max date after every reload.

You can keep your expression as it is(without any set analysis).

or May be you can have two objects with the conditional show if date = today() date then your default chart with max date in your set analysis else other one with no set analysis with max date.

[#4]

Hi

I tried something like this ,but dint work.

sum(if(Date(Bookingdate)=date(today()) or (Date(min(Bookingdate))>= and date(max(Bookingdate)),Sales))

kumanan4u i will select date from bar Chart for last 30 days.

[Anonymous]

Hi

try this

sum(  {<Bookingdate={">=$(=Date(max(Bookingdate)-30,'MM/DD/YYYY')<=$(=Date(Today(),'MM/DD/YYYY'))" > }  Sales)

or

sum(  {<Bookingdate={">=$(=Date(max(Bookingdate)-30,'MM/DD/YYYY')<=$(=Date(max(Bookingdate,'MM/DD/YYYY'))" > }  Sales)

[#6]

HI i tried multi expression , i am unsuccessful in it..

.PFA sample .qvw i am currently working on it.