Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

soniasweety
Contributor III

Separate bar

Hi all,

Jyothish KC

franky_h79

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.

beyond.PNG

Tags (2)
1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor

Re: Separate bar

soniasweety You are right. i missed that.

see attached

27 Replies
jyothish8807
Honored Contributor II

Re: Separate bar

Hi Sony,

Sorry, i am not clear about your requirement, can you please explain again ?

Br,

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: Separate bar

Hi Sony,

Check this:

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: Separate bar

Capture.PNG

Best Regards,
KC
Frank_Hartmann
Honored Contributor

Re: Separate bar

and without Total in stacked Barchart check attached!

soniasweety
Contributor III

Re: Separate bar

thank you 

franky_h79

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?

jyothish8807
Honored Contributor II

Re: Separate bar

So what will be your expected labels in next quarter ?

Best Regards,
KC
soniasweety
Contributor III

Re: Separate bar

2019Q1 2019Q2 2019Q3 2019Q4  Beyond 2019Q4

jyothish8807
Honored Contributor II

Re: Separate bar

Try this:

=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),

if(Fiscal_Period>= Year(today())&'Q'&ceil(month(today())/3),Fiscal_Period))

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

Br,

KC

Best Regards,
KC
soniasweety
Contributor III

Re: Separate bar

thanks but  as per my customer  current quarter is  2018Q4 only ... 

Community Browser