topic Re: get Dimensions name in pivot table in QlikView

get Dimensions name in pivot table

Wed, 12 Jul 2017 04:33:15 GMT

Hi Qlikview gurus!

In a pivot table, I'm trying to catch the 1st dimension field name and and display it in the second one.

Why do I need that?

I need to display that AND being able to slap dynamically the column names ("Allow pivoting" ticked).

ie E = 100/(200+3000)*200

I Can get the calculation right in static version but no way to get the "higher" dimension name dynamically.

The Dim2 formula for the static version:

=Dim2 & ' (' &

num(

aggr(NODISTINCT count(DISTINCT Metric), Dim1, Dim2 )/

aggr(NODISTINCT count(DISTINCT Metric), Dim1)

,'##0.00%')

&')'

Any thought?

jonathandienst — Wed, 12 Jul 2017 04:44:27 GMT

If this what you are looking for?

Count(DISTINCT Metric) / Count(DISTINCT TOTAL <Dim1> Metric)

- assuming Metric is a field - add the formatting (Num()) and text prefix as required.

Wed, 12 Jul 2017 05:06:53 GMT

Hi Jonathan.

Thanks a lot for answering.

My main problem is to get Dim1 name dynamically. The calculation is working if i keep DIM1 name as a field but I cannot get it from a variable

jonathandienst — Thu, 13 Jul 2017 05:21:10 GMT

Perhaps this then:

=Count(DISTINCT Metric) / Count(DISTINCT TOTAL <$(vDynamicDim1)> Metric)

Rename to the correct variable name.