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: 
nezuko_kamado
Creator
Creator

No duplicated values for rows in a chart table

Working on the booking analysis and I need a table that shows if booking was continued or cancled like as below.

nezuko_kamado_0-1680114992137.png

But what I'm getting is the duplicated variables of rows. For example, C should be continued on the third row not on the fifth row.

nezuko_kamado_3-1680115874978.png

 

Is there a way to fix it over a chart not in the loadscript?

JanRegistered:
load * inline [ ID, IDJan, StayNight, StayMonth, InputMonth
A, A, 3, Jan, 1
B, B,4 , Jan, 1
C, C,2, Feb,1
D, D, 4, Feb, 1
E, E,2, Mar, 1
F, F,3, Mar, 1
G, G, 4, Mar, 1
H, H, 2, Apr, 1];


FebRegistered:
load * inline [ID, IDFeb, StayNight, StayMonth, InputMonth
C, C, 2, Feb , 2
E, E, 2, Mar, 2
F, F, 3, Mar,2
H, H, 2, Apr, 2
I, I, 4, Apr, 2
J, J, 5, Apr, 2
K, K, 1, Apr, 2
L, L, 3, May, 2];


MarRegistered:
load * inline [ ID,IDMar,StayNight, StayMonth, InputMonth
E, E, 2, Mar , 3
F, F, 3, Mar, 3
H, H, 2, Apr, 3
I, I, 4, Apr, 3
K, K, 1, Apr, 3
L, L, 3, May, 3
M, M, 2, May, 3
N, N, 3, May, 3];


AprRegistered:
load * inline [ID, IDApr,StayNight, StayMonth, InputMonth
H, H, 2, Apr, 4
K, K, 1, Apr, 4
L, L, 3, May, 4
N, N, 3, May, 4];

Labels (3)
1 Reply
Channa
Specialist III
Specialist III

try pivot user measure as only

Channa_0-1680141909500.png

 

Channa