Different Measure by dimension

[Boseca]

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:

HUB	Section	bar_code	ACCEPTATION_ID	BODY_ID	Date
HUB ONE	Immunometria	a	a	a	1/1/2021
HUB ONE	Immunometria	b	b	b	2/1/2021
HUB ONE	Ematologia	b	b	c	2/1/2021
HUB ONE	Coagulazione	c	b	d	2/1/2021

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]

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]

Hi 

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

)