Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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