Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
rthanga2
New Contributor II

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

Re: How to make a dynamic grouped bar chart? Please help

image.png

Please ekskuse my Norglish and Swenglish typos.
Channa
Valued Contributor III

Re: How to make a dynamic grouped bar chart? Please help

u can try using wildmatch

Channa
rthanga2
New Contributor II

Re: How to make a dynamic grouped bar chart? Please help

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
New Contributor II

Re: How to make a dynamic grouped bar chart? Please help

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

Partner
Partner

Re: How to make a dynamic grouped bar chart? Please help

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

Please ekskuse my Norglish and Swenglish typos.