Line Chart

[soha1902]

Hi All,

I am using line chart in my dashboard. It showing values as per dates.

Now my requirement is if user select a specific date from date filter then chart will show selected date as well last 3 dates.

at present its showing only the seleted date.

Please help me regarding this.

[datanibbler]

Hi soha,

try set analysis:

- The parameter 1 disregards all user selections to begin with

-> Then you can ´"calculate" (all dates bigger than (selected_date)-3 and smaller_equal (selected_date)

That would be sth like this

>> Sum({1<Date = {$(= '>' & (Getfieldselections(Date)-3))}>} Sales) <<

HTH

Best regards,

DataNibbler

[soha1902]

I tried but it showing error in calculation message.

[sujeetsingh]

Use set analysis and take logic from this link

QlikView App: Set Analysis - Prior Period Comparison

[sujeetsingh]

One thing that i will suggest is that sort the date dimension in your script.

Assign them values as Rank 1,2,3....etc.

Now you need use calculated expression for the chart.

Now the logic which will work is like take dimension where Rank< current selected date rank and rank>=current selected rank-3.

Here current selected rank can be taken as variable

vRank=if(len(getfieldselected(Date))>0,Rank)

[soha1902]

Hi Sujeet thanks you very much for your help.

Can you please share or update attached qvw file for better understanding.

[perumal_41 · Accepted solution]

Hi

PFA ,try this useful for u or not

[perumal_41]

Hi Soha ,

What else need,this application is working

[SunilChauhan]

see the attched file

[soha1902]

Sorry Perumal..I didn't saw your solution.

Thank you very much.