Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
151562
Contributor II
Contributor II

Bar chart

Hello
I want to create a bar chart where I can aggregate the values ​​by month
That is, I want to show the value that the second image shows
How can I do this?

151562_0-1669221290020.png151562_1-1669221293695.png

 

 

Thank you,
FPS
Labels (1)
1 Solution

Accepted Solutions
151562
Contributor II
Contributor II
Author

I found the solution.

I used the expression sum( total<Month> value).

Thank you,
FPS

View solution in original post

4 Replies
BrunPierre
Partner - Master
Partner - Master

I could be wrong, but how about using set analysis to reproduce the second chart?

Something like;

Aggregationfunction({<NumYearMonth={202211}>}YourExpression)

151562
Contributor II
Contributor II
Author

Maybe I didn't explain it correctly, but I want it to appear every month with the same values ​​that it shows when I filter only the month
Thank you for your help
Thank you,
FPS
barnabyd
Partner - Creator III
Partner - Creator III

G'day, can you provide the expression for your chart? The answer depends on what you are calculating the percentage of.

Cheers, Barnaby.

 

Barnaby Dunn
BI Consultant
151562
Contributor II
Contributor II
Author

I found the solution.

I used the expression sum( total<Month> value).

Thank you,
FPS