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: 
nehajain2384
Contributor
Contributor

Straight table data view

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

StateCitySum(Sales_Amount)Sum(Discount)
MaharashtraMumbai100000120
MaharashtraNagpur3233456150
MaharashtraPune30098720
Madhya PradeshIndore50933334
MaharashtraBhopal34567240

 

User wants to see the data like 

 Sum(Sales_Amount)Sum(Discount)
Maharastra  
Mumbai100000120
Nagpur3233456150
Pune30098720
Madhya Pradesh  
Indore50933334
Bhopal34567240

 

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

Regards

 

7 Replies
rubenmarin

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.

nehajain2384
Contributor
Contributor
Author

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

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Sadly, there is none known to me.

The only idea I come up is the same as 

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
rubenmarin

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.

Saravanan_Desingh

Are you looking something like this? with indentation.

commQV33.PNG

nehajain2384
Contributor
Contributor
Author

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