Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Set Analysis for Current day & Multi Date Range

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

5 Replies
Highlighted
Not applicable

Re: Set Analysis for Current day & Multi Date Range

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

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

Highlighted
neelamsaroha157
Valued Contributor II

Re: Set Analysis for Current day & Multi Date Range

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.

Highlighted
Not applicable

Re: Set Analysis for Current day & Multi Date Range

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.


Highlighted
galax_allu
Valued Contributor

Re: Set Analysis for Current day & Multi Date Range

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)

Highlighted
Not applicable

Re: Set Analysis for Current day & Multi Date Range

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

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