Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveen1108
Contributor

Showing Current and Previous Values all the time in a Trend Chart based on a Bar graph

Hello,

I have a Bar Graph which shows top 4 sales of previous Quarter (Q1 2015)  by default and if i select a specific quarter it will display the respective values which works like a champ.

Now i need another trend chart below this Top 4 Sales Bar graph which should display a Trend of the sales for current and Previous Quarter Sales all the time.

Lets say if iam in Q2 2015 my Bar graph will show top 4 sales for Q1 2015 and my new trend chart should have both Q1 2015 and Q2 2015.If i select Q1 2014 then trend should show Q1 2014 and Q4 2013 (incase if there is no data for Q4 2013 it should dsiplay 0)

Some one please help me,i need this on very urgent basis.

I Appreciate for the help.

Regards,

PK

1 Solution

Accepted Solutions
praveen1108
Contributor

Re: Showing Current and Previous Values all the time in a Trend Chart based on a Bar graph

If(GetSelectedCount(Quarter)=1,

Sum({<Quarter=, QuarterNo={">=$(=Concat(DISTINCT QuarterNo)-2)<=$(=Concat(DISTINCT QuarterNo))"}>} Measure),

Sum({<QuarterNo={">=$(=Max(QuarterNo)-2)<=$(=Max(QuarterNo))"}>} Measure)

)

1 Reply
praveen1108
Contributor

Re: Showing Current and Previous Values all the time in a Trend Chart based on a Bar graph

If(GetSelectedCount(Quarter)=1,

Sum({<Quarter=, QuarterNo={">=$(=Concat(DISTINCT QuarterNo)-2)<=$(=Concat(DISTINCT QuarterNo))"}>} Measure),

Sum({<QuarterNo={">=$(=Max(QuarterNo)-2)<=$(=Max(QuarterNo))"}>} Measure)

)