Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
antoniodneto
Creator II
Creator II

Bar Chart - Trimester and Months together, is it possible?

Hey guys,

 

Its possible to create a combined bar/line chart like this?

Imagem1.jpg

 

Dec/17 =  2017 accumulated

Dec/18 =  2018 accumulated

1T19 = First 2019 trimester accumulated

and next months.

 

Tks guys!!!

21 Replies
antoniodneto
Creator II
Creator II
Author

Fala @Yoshidaqlik tudo bem?

Cara o meu ainda não está dando certo.

Segue o meu script

table_date_Mask:
Load distinct
DATA as field_date_new,
DATA as field_date_mask,
DATA as field_date_new_start
resident T696031_PAINEL_ATACADO_QLIK;

table_date_Mask:
Load distinct
QuarterEnd(DATA) as field_date_new,
Ceil(month(QuarterEnd(DATA))/3) & 'T' & YEAR(DATA) as field_date_mask,
QuarterStart(DATA) as field_date_new_start
resident T696031_PAINEL_ATACADO_QLIK;

table_date_Mask:
Load distinct
YearEnd(DATA) as field_date_new,
TEXT(Year(DATA)) as field_date_mask,
YearStart(DATA) as field_date_new_start
resident T696031_PAINEL_ATACADO_QLIK;

E dentro do Qlik continuo usando aquele min na mascara certo?

 

Yoshidaqlik
Creator II
Creator II

Oi Antonio,

ao meu ver está correto, quando você coloca a dimensão com um count qualquer os rótulos aparecem?

 

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng