Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

neha1qlikview
New Contributor II

Bar chart to show data for last month of quarter

Hello Folks,

Need some help. I am trying to create a bar chart to show data quarterly. On X axis Q1, Q2, Q3, Q4. On Y axis %

But it should show data for last month of quarter.

i.e. for Q1 it should show data for march (which is last month of first quarter)

Q2 should show data for June (which is last month of second quarter) and so on.

Thanks in advance.

2 Replies
MVP
MVP

Re: Bar chart to show data for last month of quarter

You can do this by creating flag in the script:

LOAD Date,

          Month(Date) as Month,

          MonthName(Date) as MonthYear,

          'Q' & Ceil(Month(Date)/3) as Quarter,

          If(Month(Date) = Ceil(Month(Date)/3), 1, 0) as Flag

FROM ....

Now use Quarter as dimension and Sum({<Flag = {1}>}Sales) as Expression

neha1qlikview
New Contributor II

Re: Bar chart to show data for last month of quarter

Forget to mention !! Need to add it as calculated dimension , since i can't modify load script.

Community Browser