topic Re: Straight table data view in QlikView

Straight table data view

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

Hi Everyone

I want to display data in the table chart in below format .

Right now it's showing as below . here State and City are dimensions and other two are expressions and this data is coming from DB tables

State	City	Sum(Sales_Amount)	Sum(Discount)
Maharashtra	Mumbai	100000	120
Maharashtra	Nagpur	3233456	150
Maharashtra	Pune	300987	20
Madhya Pradesh	Indore	509333	34
Maharashtra	Bhopal	345672	40

User wants to see the data like

	Sum(Sales_Amount)	Sum(Discount)
Maharastra
Mumbai	100000	120
Nagpur	3233456	150
Pune	300987	20
Madhya Pradesh
Indore	509333	34
Bhopal	345672	40

Please let me know of there is a way of handling this from UI

Regards

Re: Straight table data view

rubenmarin — Thu, 18 Jun 2020 18:43:41 GMT

Hi, you can show something close to that using a pivot table.

To have it in a straigth table in the same column I think you will need some help of script to join State and City in the same field and use another field to define the order to show values.

Re: Straight table data view

nehajain2384 — Mon, 22 Jun 2020 11:24:31 GMT

Thanks ...but with Pivot table also it will be still in other column ... is there any way to do it from UI , instead of script

Re: Straight table data view

MindaugasBacius — Mon, 22 Jun 2020 11:59:37 GMT

Sadly, there is none known to me.

The only idea I come up is the same as Rubenmarin.

Re: Straight table data view

Brett_Bleess — Wed, 08 Jul 2020 12:19:41 GMT

Have a look at the following Design Blog post, this is going to be script related, but may put you on the right track to get what you want potentially.

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett

Re: Straight table data view

rubenmarin — Wed, 08 Jul 2020 17:50:01 GMT

If you really need to look like that and for some reason you can't use a pivot table, you can use a new field that merges State and City values in that field, and use another field to set the order on how values should be shown.

Re: Straight table data view

Saravanan_Desingh — Thu, 09 Jul 2020 02:49:29 GMT

Are you looking something like this? with indentation.

Re: Straight table data view

nehajain2384 — Mon, 13 Jul 2020 10:56:59 GMT

Yes it should show state as a header for city and expression results