topic Re: Show non-selected dimensions in a table - dimensions are calculated in QlikView

Show non-selected dimensions in a table - dimensions are calculated

Thu, 23 Apr 2015 10:33:30 GMT

Is it possible to use calculated dimensions and have them be displayed in a similar way to ordinary dimensions as in the link provided Question - How to show all dimensions.... I'm thinking the answer is no after some experimentation but would be delighted if it was yes.

The calculated dimension in the table with column Products - Top 5 should stay displayed no matter selections to product (=Aggr(If(Rank(Sum(Sales))<=5,Only(Product)), Product) to calculate dimension initially).

I've updated the file provided in the linked question above and added my failed example (Copy of Main tab sheet).

Re: Show non-selected dimensions in a table - dimensions are calculated

sunny_talwar — Thu, 23 Apr 2015 10:54:12 GMT

I am not entirely sure of the end goal, but take a look, this might be what you are looking for. PFA

Best,

Sunny

Re: Show non-selected dimensions in a table - dimensions are calculated

sunny_talwar — Thu, 23 Apr 2015 10:59:49 GMT

Disregard the first application as there was a slight change to the application. PFA

Re: Show non-selected dimensions in a table - dimensions are calculated

Thu, 23 Apr 2015 11:01:15 GMT

Thanks sunny,

I'm hoping that if I click on the dimension Product or calculated dimension Products - Top 5 option (say Kiwi) then the Table on the right (with the Products - Top 5 column) still displays all options in a similar fashion to the table on the left.

Re: Show non-selected dimensions in a table - dimensions are calculated

sunny_talwar — Thu, 23 Apr 2015 11:03:36 GMT

Check out the second qvw file I have attached, I think its doing exactly that.

Re: Show non-selected dimensions in a table - dimensions are calculated

Thu, 23 Apr 2015 11:05:12 GMT

That looks perfect Sunny, thanks for that. I was missing was the {1} From Only({1}Product)) .

Ultimately going to be used in a chart with colour changes.

Thanks again,

Colin

Re: Show non-selected dimensions in a table - dimensions are calculated

sunny_talwar — Thu, 23 Apr 2015 11:06:14 GMT

Awesome! I am glad it worked.

Best,

Sunny