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!!!

1 Solution

Accepted Solutions
Yoshidaqlik
Creator II
Creator II

opa Antonio

tudo bem?

só corrigindo a postagem da formula da mascara

Ceil(month(QuarterEnd(field_date))/3) & 'T' & YEAR(field_date)

o  restante parece estar ok

 

 Sem título.png

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

View solution in original post

21 Replies
jmartineze
Partner - Creator
Partner - Creator

Hello Antonio, 

try to create another a table with this values and use this new fields in your chart, or maybe add a calculated dimension.

 

J.

antoniodneto
Creator II
Creator II
Author

I don't think if it will work for me, because I will update every week. I'm  looking for something automated. 

Yoshidaqlik
Creator II
Creator II

Hi 

you can do something automated using the script load with Resident

something like:

table_date_Mask:
Load distinct
field_date as field_date_new,
field_date as field_date_mask
resident your_table;

table_date_Mask:
Load distinct
QuarterEnd(field_date) as field_date_new,
QuarterName(field_date) as field_date_mask
resident your_table;

table_date_Mask:
Load distinct
YearEnd(field_date) as field_date_new,
Year(field_date) as field_date_mask
resident your_table;

 

the problem i see this way is that it will take a lot of processing

but the result is as expected

Capture.PNG

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
antoniodneto
Creator II
Creator II
Author

Hi,

I think it can works for me. Could you help do create my dash?

I applied your script but how I use on chart?

Tks!!

Yoshidaqlik
Creator II
Creator II

if it is an accumulated sum:

sum(if(field_date <=field_date_new, value))

 

it is important that this new table is not linked to any other table

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
Yoshidaqlik
Creator II
Creator II

on the x axis place the field 

field_date_mask

 

in the classification put the field

field_date_new

 

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
antoniodneto
Creator II
Creator II
Author

Sorry where is classfication to use the field?

 

Yoshidaqlik
Creator II
Creator II

Capture.PNG

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
antoniodneto
Creator II
Creator II
Author

HI,

I think is something missing here. Look it.

9288a316641848a1a4c9e53a898cb396.png