Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ozymandias
Contributor
Contributor

Table Alteration

I have a table with rows and seat data. The problem is, the seat just keeps going up. So, if I have 10 rows of ten seats, the seat data goes from 1--100, when I want it to reset to 1 when the row increments. How do I do this? Can I make if statements outside of a load statement? And I can't set variables inside of a load statement.

2 Replies
Marcos_rv
Creator II
Creator II

What you can do is to have time intervals, and when you click on an X value, for example 6pm, the graph shows the X values ​​such as 6:00, 6:15, 6:45 etc., this is done first. integer value of the hour, and declaring a master dimension of the gerarchy type, here you first put the integer value and as a second dimension you add the one that contains the hour and minutes.

Is that what you had in mind?

Regards!!!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

AutoNumber(RecNo(), Row) as Seat

-Rob