Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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

AutoNumber(RecNo(), Row) as Seat

-Rob