topic Re: Use field names as Dimension values in QlikView

Use field names as Dimension values

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

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)

(Image 2)

Re: Use field names as Dimension values

rwunderlich — Mon, 31 Jul 2017 16:42:51 GMT

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

Re: Use field names as Dimension values

arvind_patil — Mon, 31 Jul 2017 16:45:00 GMT

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

Re: Use field names as Dimension values

julioarriaga — Mon, 31 Jul 2017 16:50:28 GMT

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!