Discussion board where members can get started with QlikView.
i have a bar chart with all the quarters .
but my requirment is i want to show 2018Q4 2019Q1,2019Q2,2019Q3 and beyond 2019Q3 means 2019Q4 2020Q1 2020Q2 ...till last quarter as separate bar. as shown in image, !
in attached qvw - first sheet first chart i need to show like below.
Go to Solution.
soniasweety You are right. i missed that.
Sorry, i am not clear about your requirement, can you please explain again ?
and without Total in stacked Barchart check attached!
jyothish8807 but " can we make this dynamic? bcz if i move to next quarter
again i need to change the calucalted dimension right?
how can w handle this?
So what will be your expected labels in next quarter ?
2019Q1 2019Q2 2019Q3 2019Q4 Beyond 2019Q4
=if(Fiscal_Period > Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),'Beyond '& Year(Addmonths(today(),9))&'Q'&ceil(month(Addmonths(today(),9))/3),
As per the logic the dimension will start from 2018Q3 (Current Quarter) but you do not have data for this quarter, so it will start from 2018Q4
thanks but as per my customer current quarter is 2018Q4 only ...