Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rthanga2
Contributor
Contributor

How to make a dynamic grouped bar chart? Please help

SetNameScore
1A10
1B12
1C15
2A9
2B14
2C16
3A12
3B14
3C13
4A11
4B12
4C14

 

My data is like this every week i run the script it will add scores for A,B,C as a new set. i.e when i run this week it add "Set" as 5 for each of A,B,C and their scores. Now what i need is a bar chart showing height as score and only taking last 3 weeks i.e when i run this week since it will be set 5 it should take set's 5,4,3 and give grouped bar charts by name.

5 Replies
Vegar
MVP
MVP

Channa
Specialist III
Specialist III

u can try using wildmatch

Channa
rthanga2
Contributor
Contributor
Author

Hello thanks for the reply. Can you also explain how i can get the change in the last two sets i.e between 4 and 3 keeping in mind that next week it will be 5 and 4 and will keep changing?
rthanga2
Contributor
Contributor
Author

Hello thanks for the reply. Can you also explain how i can get the change in the last two sets i.e between 4 and 3 keeping in mind that next week it will be 5 and 4 and will keep changing? and graph this change as Name vs change

Vegar
MVP
MVP

The graph will ajust to the three OR two latest Sets with the expressions below. If you add another set 5, the graph will adjust. 

image.png