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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Addison_Qlik
Contributor
Contributor

How to create table in Qlik sense

Is there any way to do this in Qlik sense?

Labels (1)
3 Replies
Lisa_P
Employee
Employee

What data do you have and what data do you want it to work out ?

justISO
Specialist
Specialist

Hi, there are multiple ways, depends on where you want to have this tables calculated - in load script or report level. In load script, you can try something like this:

main:
load * inline [
no_of_works, no_of_staff
5,10
6,15
7,10
8,5
9,15
10,6
12,10];


aggr:
load 
if(no_of_works>=5 and no_of_works<=6, '5-6', 
if(no_of_works>=7 and no_of_works<=9, '7-9',
if(no_of_works>=10, '10 and more', 'other'))) as no_of_works_aggr,
sum(no_of_staff) as no_of_staff_aggr
resident main
group by
if(no_of_works>=5 and no_of_works<=6, '5-6', 
if(no_of_works>=7 and no_of_works<=9, '7-9',
if(no_of_works>=10, '10 and more', 'other')));

 

Saurabh_K14999
Contributor III
Contributor III

EMPLOYEE_TABLE:
LOAD * Inline [
No Weeks, No Staff
5,10
6,15
7,10
8,5
9,15
10,6
12,10];

Regards, 

SK