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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

Use field names as Dimension values

Hi everyone,

Thanks in advance for your help. I have two fields "Total Sales" and "Gross Sales" (just an example, I have way more) that I wish to show in the way of Image 1, and information is as Image 2.

Kind regards.

(Image 1)

Capture2.PNG

(Image 2)

Capture.PNG

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

My first response is that it's as simple as creating a Straight Table with expressions like "Sum([Total Sales])" and then checking "Horizontal" on the Presentation tab.  I suspect you may be trying to do something more sophisticated?

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

My first response is that it's as simple as creating a Straight Table with expressions like "Sum([Total Sales])" and then checking "Horizontal" on the Presentation tab.  I suspect you may be trying to do something more sophisticated?

-Rob

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Julio,

First create Inline table

DimInline:

LOAD * INline [

Dim

[Total sales]

[Gross Sales]

];

Use  expression in Straight table:

Sum({<Dim={"Total sales"}>}Total Sales)

Sum({<Dim={"Gross Sales"}>}Total Sales)



Thanks,

Arvind Patil

julioarriaga
Creator II
Creator II
Author

Indeed, my final idea is far more complex, but I think I will keep it simple in order to not convolute innecesarily the question. When I advance more my app, I will post other questions.

Thank you for your response!