Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

soniasweety You are right. i missed that.

see attached

View solution in original post

27 Replies
jyothish8807
Master II
Master II

Hi Sony,

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

Br,

KC

Best Regards,
KC
jyothish8807
Master II
Master II

Hi Sony,

Check this:

Best Regards,
KC
jyothish8807
Master II
Master II

Capture.PNG

Best Regards,
KC
Frank_Hartmann
Master II
Master II

and without Total in stacked Barchart check attached!

soniasweety
Master
Master
Author

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
Master II
Master II

So what will be your expected labels in next quarter ?

Best Regards,
KC
soniasweety
Master
Master
Author

2019Q1 2019Q2 2019Q3 2019Q4  Beyond 2019Q4

jyothish8807
Master II
Master II

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
Master
Master
Author

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