Qliksense Set expression add dimension calculatıon

krmvacar — Sat, 28 Sep 2024 11:53:56 GMT

Hi All,

ı have straight table dimension like this

=if(statü like 'Ok' or ([statü like 'NoOk' and [Quality]>0),Type)

I want to dimension calculatıon add in set expression.

My set expression:

sum(
{<
[CompanyCode]={"1300"},
[MaterıalCode]={"A300"},
[TypeMaterıal]={"1","2","3"}
>-<
[Flag]={"X"},
[Group] ={"*Gal.Fas.Boy.Rlo"}
>}Sales)

Thank you so much

Re: Qliksense Set expression add dimension calculatıon

zar — Tue, 08 Oct 2024 20:03:07 GMT

Hi! Based on the provide information, one way to have it is like I mentioned below.

Considering the data:

DATA:
LOAD * INLINE [
statü, Quality, Type, CompanyCode, MaterıalCode, TypeMaterıal, Flag, Group, Sales
Ok,0,TYPE_A,1300,A300,1,Y,AAAA,20
NoOk,20,TYPE_B,1300,A300,2,Y,BBBB,30
NoOk,20,TYPE_B,1300,A300,2,X,AAA_Gal.Fas.Boy.Rlo,13
NoOk,0,TYPE_B,1300,A300,2,Y,BBBB,30
Ok,20,TYPE_A,1300,A400,1,Y,AAAA,22
Ok,30,TYPE_A,1300,A300,3,Y,AAAA,33
]
;

Only 3 rows highlighted in green in the screenshot are true for your conditions.

Settings for the table:

DimensionExpression (measure)Expression screenshot

Expression:

{<[CompanyCode]={'1300'}

,[MaterıalCode]={'A300'}

,[TypeMaterıal]={'1','2','3'}

,[Flag]-={'X'}

,[Group]-={"*Gal.Fas.Boy.Rlo"}

Sum(

{

<[statü]={'Ok'}>

<[statü]={'NoOk'},Quality={">0"}>

}

Sales

)

topic Qliksense Set expression add dimension calculatıon in App Development

Qliksense Set expression add dimension calculatıon

Re: Qliksense Set expression add dimension calculatıon