topic Straight table in QlikView

Straight table

d_ankusha — Wed, 25 Nov 2020 16:16:04 GMT

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.:

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

How can I achieve this?

kakani87 — Thu, 05 Jul 2018 06:06:24 GMT

Actually Subtotals they are not possible in straight table.

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

thevingo — Thu, 05 Jul 2018 06:10:18 GMT

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 — Thu, 05 Jul 2018 06:10:26 GMT

Hi,

Try with attached file

Saludos.

d_ankusha — Thu, 05 Jul 2018 06:20:15 GMT

Thanks everyone