topic Set Analysis for Current day & Multi Date Range in QlikView

Set Analysis for Current day & Multi Date Range

Fri, 09 Sep 2016 07:38:21 GMT

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. @ !

Re: Set Analysis for Current day & Multi Date Range

Fri, 09 Sep 2016 18:21:51 GMT

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

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

Re: Set Analysis for Current day & Multi Date Range

neelamsaroha157 — Fri, 09 Sep 2016 18:32:33 GMT

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.

Re: Set Analysis for Current day & Multi Date Range

Mon, 12 Sep 2016 06:18:53 GMT

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.

Re: Set Analysis for Current day & Multi Date Range

Anonymous — Mon, 12 Sep 2016 13:28:00 GMT

try this

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

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

Re: Set Analysis for Current day & Multi Date Range

Mon, 12 Sep 2016 16:52:32 GMT

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

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