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

27 Replies
jyothish8807
Master II
Master II

Since you do not have data for 2018Q3, it will start from 2018Q4 only. So what will your customers current quarter in Jan 2019 ?

I am just trying to understand the logic.

Br,

KC

Best Regards,
KC
soniasweety
Master
Master
Author

that i  need to check  ..  and get back on this . as they shared the latest file in that  they mentioned current quarter is 2018Q4

soniasweety
Master
Master
Author

just checked  internally  saying that  Nov is the Q1  for the customer

[ need to check with bussiness]

so is there anything needs to chnge in caluclated dimension ?franky_h79

jyothish8807 

Q1 starts from Nov

dec

jan

Q2

Feb ,mar ,aprl

Q3

may jun jul

Q4

aug sep oct

soniasweety
Master
Master
Author

Hi

Frank Hartmann

Jyothish KC

any update on this ?    

soniasweety
Master
Master
Author

Hi felipedl

tresescocan you look into this?

Frank_Hartmann
Master II
Master II

check attached qvw!

soniasweety
Master
Master
Author

thank you .. same question   its dynamic right?  

and  instead of  lengthy  calucalted dimension   can we  place in  variable and cant we use that in  cal dimension?

Frank_Hartmann
Master II
Master II

Yes it is dynamic.

See attached for variable use

Frank_Hartmann
Master II
Master II

for dynamic check just change the systemtime of your pc. the chart should change accordingly!

soniasweety
Master
Master
Author

thank you so much sir,..  its working   just give me sometime i will close this thread with correct answer !!