Different type of measure (EURO and NUM of PERSON)

[clovati]

HI!

I have a table with 4 accounts and 4 number:

ACCOUNT, VALUE

A, 3000

B, 2000

C, 20

D, 30

A and B are Value in Euros.

C and D are number of persons.

I have to put 2 buttons ('AS IS' and 'THOUSAND') because

A and B can toggle from EUROS and  THOUNSAND of EUROS

but C and D have always to be in NUMBER OF PERSONS and never change their type of view in QVW.

I've tryied with a variable but ko 😞

I can put in source table 1000 for  A,B

and 1 for C, D

then I would like the variable be like the value of the field but I am not able to give a dinamic value to the variable.

The measure then should be:

Sum (VALUE)/$(v_Thousand)

where v_Thousand should be

always 1 (set by BUTTON 'AS IS') or

1 for C,D and 1000 for  A,B (set by BUTTON 'THOUSAND').

thk a lot

[#2]

Hope this helps you

[clovati]

Thx, but I have lot of accounts then I cannot write  in qwv, I need the fastest way to show the values toggling beetween two types of values.

[#4]

HI,

you could create Flag field in your script, marking all accounts which are in  Euros with 1 and all others with 0.

then in your expression you can simply put

=PICK(MATCH(flag,'1','0'),
(VALUE)/$(V_THOUSAND),(VALUE))

Please see attached qvd. Hope this helps!