Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need help in buliding a Gauge chart which shows weekly changes

Hi Experts,

I'm new to clikview and really need your help.


I have a data and weekly data will be appended to this file.

Based on selected weeks, i want to track if there is any difference in records,
if there is difference in count the gauge should point at 'Change' if not 'No Changes' and other gauge should point out increased or decrease in those weeks.

Below is the sample data,

1) in the below data If i select weeks 27/20/2017 and 12/11/2018, one gauge should show as changed since record count decreased, and other gauge should show decreased.

    If i select weeks 27/20/2017 and 2/10/2018, one gauge should show as No changes and other gauge can point in center, since record count matches.

2) second thing if possible, a box which show which items(game column) are not common in those selected weeks.

sample data:  

S.noGameRule1Rule2WeekWeek no
1Cricket11 members gamesix balls per over27/10/20171
2basketball5 members game Player Positions27/10/20171
3Vollyball6 members game Maximum of three hits per side 27/10/20171
4Cricket11 members gamesix balls per over2/10/20182
5basketball5 members game Player Positions2/10/20182
6Vollyball6 members game Maximum of three hits per side 2/10/20182
7Cricket11 members gamesix balls per over12/11/20183
8basketball5 members game Player Positions12/11/20183
9Cricket11 members gameThree balls per over18/11/20184
10basketball5 members game Player Positions18/11/20184
11Vollyball6 members game Maximum of three hits per side 18/11/20184
12Hockey11 members game
Offside (or two-line)Pass
18/11/2018

4

0 Replies