Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveen1108
Contributor

Display Previous Quarter Sales in a Bar Chart as a default View

Hello,

Can someone help me with logic for below:

I have Bar chart which should display default view of previous quarter sales but if i select the specific quarter it should display only selected quarter sales. my selection is Quarter in format Apr-Jun 2015 etc..

Some one Please help me with Previous Quarter Sales Logic and how we can display a default view of bar chart to previous and later to specific selected quarter sales.

Thanks for the help in advance.

Regards,

PK

1 Solution

Accepted Solutions
praveen1108
Contributor

Re: Display Previous Quarter Sales in a Bar Chart as a default View

This helps!!

If(GetSelectedCount(Quarter)=0,

Sum({<QuarterNum={$(=Max({1<Year={$(=Max({1}Year))}>}QuarterNum-1))}>}MEASURE),

Sum(MEASURE))

1 Reply
praveen1108
Contributor

Re: Display Previous Quarter Sales in a Bar Chart as a default View

This helps!!

If(GetSelectedCount(Quarter)=0,

Sum({<QuarterNum={$(=Max({1<Year={$(=Max({1}Year))}>}QuarterNum-1))}>}MEASURE),

Sum(MEASURE))

Community Browser