topic Re: Additional Dimension in QlikView

Additional Dimension

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

Hello Team,

Could you help me to create an extra dimension to collapse measures? Currently, measures are calculated by set analysis. I need to created dimension to collapse that measures. Is it possible? Of course, I can't base on ([L1 - P/L Piece], [Account Type],[L3 - Package]).

eg of measure: COGS = sum({<PeriodType = {Current}, [L1 - P/L Piece] = {"RESTAURANT P/L"}, [Account Type] = {"PL"}, [L3 - Package] = {"COGS"}>}$(vReportCurrency))

Regards

Jacek.

Re: Additional Dimension

parthesh — Fri, 17 Feb 2017 11:25:58 GMT

Hello Jacek,

please elaborate your issue, i am not able to get exact requirement.

thanks

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 12:18:37 GMT

Not sure I understand what you are trying to do. Would you be able to elaborate more and may be share a sample with the desired output you are looking to get?

Re: Additional Dimension

Anonymous — Fri, 17 Feb 2017 12:51:12 GMT

Hi Jacek,

I assume you are trying to calculate value in same dimension,like COGS % and COL% which are not presented in the dimension.It would be better if you share sample data and expected output in a excel.

Attached application may help you

Re: Additional Dimension

Anonymous — Fri, 17 Feb 2017 14:07:03 GMT

Hello Gents,

Thank you for your comments. The effect that I wish to receive is a special dimension. So that the user can use the options expand/collapse. It has to be done for individual groups as pictured.

Regards

Jacek.

Re: Additional Dimension

vinieme12 — Fri, 17 Feb 2017 14:10:40 GMT

can you post a sample app? it's easier to assist

Preparing examples for Upload - Reduction and Data Scrambling

We can actually do it in the frontend using valuelist(), but then your expression will be a mess, I would suggest creating another field during load where you map those categories

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 14:12:28 GMT

I am assuming that Revenue, # Tickets an so on... are all individual expressions?

Re: Additional Dimension

Anonymous — Fri, 17 Feb 2017 14:16:57 GMT

Yes Sunny, they are individual expressions.

@ Vineeth, I can't upload application, because of business data. I will try to prepare other application with just sample od data.

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 14:27:15 GMT

May be see if this sample can give you some direction

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 14:30:35 GMT

Or use The Crosstable Load to make your life easier

Re: Additional Dimension

Anonymous — Fri, 17 Feb 2017 14:51:06 GMT

Sunny, great sample, very close to the final effect. The last option is to have (after unchecking the option "Always Fully Expand") eg Revenue with the value when is expanded.

Atm when I lunch that option, I don't have value.

Regards

Jacek.

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 14:52:44 GMT

Not sure I follow your question?

Re: Additional Dimension

Anonymous — Fri, 17 Feb 2017 14:54:43 GMT

Yes, it is correct direction.

Re: Additional Dimension

sunny_talwar — Fri, 17 Feb 2017 14:58:54 GMT

So you have what you need or let us know if you still need help with anything

Re: Additional Dimension

Anonymous — Sat, 18 Feb 2017 17:24:45 GMT

Hi walaszek,

Attached the application , this requires some input like which column need to sum , count or avg in inline wizard. % calculation need to be done separately and merged with previous table

assuming this application may be the solution for your requirement

Re: Additional Dimension

Anonymous — Mon, 20 Feb 2017 11:30:57 GMT

Hello Sunny,

Unfortunately I was not able to obtain such effect as in your example. The problem occurs at Expression level. In your example, you summed columns from the model.I need to use my expressions with set analysis.

I attach an example of data whose works without the proposed changes.

Regards

Jacek.

Re: Additional Dimension

Anonymous — Mon, 20 Feb 2017 11:36:29 GMT

Hello Prabu,

Unfortunately, my example is not so simple. If the task was to build a dimension to the columns of the model, there will be no problems.

Here you have to build a dimension to the expressions, so that you can group these expressions and allow the user the option to expand / collapse

Regards

Jacek.

Re: Additional Dimension

sunny_talwar — Mon, 20 Feb 2017 16:21:27 GMT

I think you have section access in your application. I am unable to open the file

Re: Additional Dimension

Anonymous — Wed, 24 May 2017 12:16:15 GMT

Sorry, I forgot to thank, your solution works, thank Sunny.

Regards

Jacek.