topic Re: Dynamic Dimensions - QlikView in QlikView

Dynamic Dimensions - QlikView

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

I will greatly appreciate your guidance on this -

We have 3 pivot tables in a dashboard as 3 sheets –

The measures in all the 3 are the same (premium, commission, and client count)
The dimensions are Coverage, Carrier, and Wholesaler (one for each of the pivots)

What is a good way to use 1 pivot table (instead of 3) and have a dynamic dimension that the user can select (Coverage or Carrier or Wholesaler)?

I have built an inline table called Selection with values Coverage, Carrier, Wholesaler.

Also using =GetCurrentSelections(Selection) to get the value of user selection in the pivot as a dimension.

But it shows up as ‘Selection: Coverage’ (when Coverage is selected) rather than listing the values of the dimension Coverage.

Thanks for your suggestions - and please let me know if there is a simpler way to do it.

Regards

Re: Dynamic Dimensions - QlikView

sunny_talwar — Thu, 08 Feb 2018 19:35:42 GMT

Try adding dollar sign expansion with GetFieldSelections

$(=GetFieldSelections(Selection))

Re: Dynamic Dimensions - QlikView

peterkumar — Thu, 08 Feb 2018 19:51:26 GMT

Thanks Sunny.

Much appreciated!

Re: Dynamic Dimensions - QlikView

sunny_talwar — Thu, 08 Feb 2018 19:52:38 GMT

No problem at all ... Glad I am able to help

Re: Dynamic Dimensions - QlikView

peterkumar — Thu, 08 Feb 2018 21:52:50 GMT

One related question

One of my inline field values has a space in it - e.g., Wholesaler Type. It shows fine in the list box for the user to select; but it does not work in the dimension. Is there a work around for it?

Thanks again!

We have 3 pivot tables in a dashboard as 3 sheets –

The measures in all the 3 are the same (premium, commission, and client count)
The dimensions are Coverage, Carrier, and Wholesaler (one for each of the pivots)

What is a good way to use 1 pivot table (instead of 3) and have a dynamic dimension that the user can select (Coverage or Carrier or Wholesaler)?

Re: Dynamic Dimensions - QlikView

sunny_talwar — Thu, 08 Feb 2018 21:58:00 GMT

In that case, try this

$(='[' & GetFieldSelections(Selection) & ']')

Re: Dynamic Dimensions - QlikView

peterkumar — Thu, 08 Feb 2018 22:10:09 GMT

Thanks Sunny.

That worked fine too!

However, it does not pick up Dimension values that have a space in them - e.g., Wholesaler Type has values Public, Private, and Non Profit. It picks up Public and Private but not Non Profit. Is there a workaround for that?

Thanks again!!

Re: Dynamic Dimensions - QlikView

sunny_talwar — Thu, 08 Feb 2018 22:11:49 GMT

Can you show an image of what you see? I am not sure I understand what you might have?

Re: Dynamic Dimensions - QlikView

peterkumar — Thu, 08 Feb 2018 22:24:31 GMT

Thanks Sunny -

This is what I am getting -

This is what I should be getting -

So the Non Profit gets left out - I guess due to the space.

Thanks again!

Re: Dynamic Dimensions - QlikView

peterkumar — Fri, 09 Feb 2018 19:57:43 GMT

Hi Sunny,

Any thoughts on the above examples? The dimension is LEGAL_ENTITY and the value 'Non Profit' gets left out.

Thanks very much!

Re: Dynamic Dimensions - QlikView

peterkumar — Fri, 09 Feb 2018 22:10:09 GMT

Hi Sunny,

It's working now. I had the dimension limit to 2 - so changed it to 5 and seeing all my values.

Thanks again for all your help!

Re: Dynamic Dimensions - QlikView

sunny_talwar — Sat, 10 Feb 2018 01:02:53 GMT

Oh nice, I am glad it finally worked for you

Re: Dynamic Dimensions - QlikView

shiveshsingh — Sat, 10 Feb 2018 02:20:27 GMT

Hi stalwar1‌

It can happen through one more way, I guess.

Make a dimension inline table and in pivot table , we can put enable condition for each dimension like

getfieldselection(Dimension) = 'Selection' for 1 dimension and so on for other 2.

It should work,right?

Re: Dynamic Dimensions - QlikView

sunny_talwar — Sun, 11 Feb 2018 00:57:13 GMT

I believe it should work

Re: Dynamic Dimensions - QlikView

shiveshsingh — Sun, 11 Feb 2018 02:38:31 GMT

Thanks,

Re: Dynamic Dimensions - QlikView

davidniche — Fri, 07 Jun 2019 15:32:31 GMT

This fixed my 2 day struggle > thanks 🙂