Variable

didine — Sun, 04 Dec 2022 16:38:23 GMT

Hello , i have a question please if you can help me .

I have table :

Cat. Produ. V1. V2. Target

Cat1. P1 30. 50. >

Cat1. P1 40. 30. <

Cat1. P2 60. 50. =

Cat2. P12 60. 50. >

I want :

V1 =if produ like p1

,If (v1>v2 and target= '>' , 1 , 0)+ ....v1>v2 and target= '>' , 1 , 0)+

I for Produ variable v1 telle me

For produ how much i have true

I wante do it for cat like drile down (cat_produ)

But i cant

Van you help me

Re: Variable

zar — Sun, 22 Jan 2023 13:42:25 GMT

Hi!

I would suggest go with script approach, so you can create your field on back end:

DATA:

Load

[Cat]

,[Produ]

,[V1]

,[V2]

,[Target]

,[Dif_Sign]

,[Num_Target]

,IF ([Dif_Sign]=[Num_Target], 'True', 'False') as ConditionCheck

;

Load

[Cat]

,[Produ]

,[V1]

,[V2]

// checking if V1 is < = < V2, the result will be -1 if negative, 0 if equal, 1 if positive.

//We add 2 so we can have 1,2,3 as our Numerical target

,Sign(V1-V2)+2 as Dif_Sign

,[Target]

,Match([Target],'<','=','>') as Num_Target //convert Target into numerical so we can compare easy. Convertin to '<' = 1, '=' = 2, '>' = 3

;

Load * Inline [

Cat, Produ, V1, V2, Target

Cat1, P1, 30, 50, >

Cat1, P1, 40, 30, <

Cat1, P2, 60, 50, =

Cat2, P12, 60, 50, >

Cat2, P13, 50, 50, =

]

;

If you are lazy and prefer inefficient solution, just create a dimension like this:

=IF (Sign(V1-V2)=-1 and Target = '<', 'True',

IF (Sign(V1-V2)=0 and Target = '=', 'True',

IF (Sign(V1-V2)=1 and Target = '>', 'True',

'False')))

topic Variable in App Development

Variable

Re: Variable