topic Re: Line Chart in QlikView

Line Chart

soha1902 — Wed, 18 Jun 2014 10:08:10 GMT

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.

Re: Line Chart

datanibbler — Wed, 18 Jun 2014 10:10:17 GMT

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

Re: Line Chart

soha1902 — Wed, 18 Jun 2014 10:18:28 GMT

I tried but it showing error in calculation message.

Re: Line Chart

sujeetsingh — Wed, 18 Jun 2014 10:18:43 GMT

Use set analysis and take logic from this link

QlikView App: Set Analysis - Prior Period Comparison

Re: Line Chart

sujeetsingh — Wed, 18 Jun 2014 10:28:11 GMT

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)

Re: Line Chart

soha1902 — Wed, 18 Jun 2014 10:43:42 GMT

Hi Sujeet thanks you very much for your help.

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

Re: Line Chart

perumal_41 — Wed, 18 Jun 2014 11:19:02 GMT

PFA ,try this useful for u or not

Re: Line Chart

perumal_41 — Thu, 19 Jun 2014 05:06:16 GMT

Hi Soha ,

What else need,this application is working

Re: Re: Line Chart

SunilChauhan — Thu, 19 Jun 2014 05:52:21 GMT

see the attched file

Re: Line Chart

soha1902 — Thu, 19 Jun 2014 06:17:14 GMT

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

Thank you very much.