Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
d_ankusha
Creator II
Creator II

Straight table

Hi everyone,

I have a following data loaded inline.

Data:

Table:

Load * Inline [

State, City, Employee_Count

Maharashtra, Mumbai, 100

Maharashtra, Pune, 150

Gujarat, Surat, 80

Gujarat, Ahmedabad, 120

];

I want to have following output in straight table.:

Capture3.PNG

Also I want to have scripting done in backend and changes to reflect in frontend.

How can I achieve this?

1 Solution

Accepted Solutions
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try with attached file

Saludos.

View solution in original post

4 Replies
kakani87
Specialist
Specialist

Actually Subtotals they are not possible in straight table.

using pivot table can be displayed as below, Check this may be helpful

subtotal.jpg

thevingo
Creator
Creator

hi

you can load another inline as

[City

Mumbai

Pune

Maharashtra

Surat

Ahmedabad

Gujarat]

Then you've to calculate based on that.

I don't remember exactly but someone may help.

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Try with attached file

Saludos.

d_ankusha
Creator II
Creator II
Author

Thanks everyone