topic Different Measure by dimension in App Development

Different Measure by dimension

Boseca — Mon, 20 Dec 2021 10:17:37 GMT

I Everybody, i have to replicate an Excel Table on Qliksense, and the problem is to translate the different approach of Excel to Qlik.

As you can see in the table below, in the Unit/Month expression, we have 3 different measures.

The problem is that in the Section Dimension, the real field start from the 3rd row, the first 2 is not a real dimension.

Objective:

HUB	Section	Units/month	Days	Units/day
HUB ONE	Preanalitica	=count(distinct bar_code) -> 164708	26	6.335
	Firma	=Count(DISTINCT ACCEPTATION_ID) -> 27844	21	1.326
	Immunometria	=Count(DISTINCT BODY_ID) -> 9795	20	490
	Ematologia	=Count(DISTINCT BODY_ID) -> 25645	26	986
	Coagulazione	=Count(DISTINCT BODY_ID) -> 8844	26	340

Data structure:

I know, that we should avoid this kind of adjustment, but we really need this so the user can easly export the data.

Thank you very much for your support!

JHuis — Wed, 29 Dec 2021 10:19:38 GMT

Hello Bosica,

my question is:

The problem is that in the Section Dimension, the real field start from the 3rd row, the first 2 is not a real dimension.

So is this only one row? or is this some sort of total

brunobertels — Thu, 30 Dec 2021 16:57:02 GMT

create your table with a synthetic dimension using valuelist function

and pick(match( function for your mesure :

exemple below :

My Dimension:

Valuelist('A','B','C')

My Expression:

pick(match(valuelist('A','B','C')

'A','B','C')

,mesure for A

,mesure for B

,mesure for C

)