topic Re: How to make expression with constant value base on dimension required ? in QlikView

How to make expression with constant value base on dimension required ?

danipudianto — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I has data like that

load * Inline

[LINI1,TAHUN1,BULAN1,JNS1,QTY1

DISK,2017,10,NG,2

DISK,2017,10,NG,4

DISK,2017,10,NG,1

DISK,2017,10,PROD,150

DISK,2017,10,REP,10

RIM,2017,10,NG,2

RIM,2017,10,NG,1

RIM,2017,10,PROD,170

RIM,2017,10,REP,11

];

How to fill expression PROD value QTY based on LINI1 and JNS1='PROD' in all records

See picture below

Regards

Dani

Re: How to make expression with constant value base on dimension required ?

PrashantSangle — Wed, 14 Feb 2018 08:35:34 GMT

Aggr(max({<JNS1={'PROD'}>}Qty),LINI1)

Regards

Re: How to make expression with constant value base on dimension required ?

tresB — Wed, 14 Feb 2018 08:57:13 GMT

Sum(total <LINI1> {<JNS1={'PROD'}>}QTY1)

Re: How to make expression with constant value base on dimension required ?

danipudianto — Wed, 14 Feb 2018 09:25:38 GMT

Dear Tresesco,

It's Work. Thanks

Re: How to make expression with constant value base on dimension required ?

PrashantSangle — Wed, 14 Feb 2018 09:54:22 GMT

another possible solution could be

max(TOTAL<LINI1>{<JNS1={'PROD'}>}QTY1)

Regards

Re: How to make expression with constant value base on dimension required ?

danipudianto — Wed, 14 Feb 2018 10:01:56 GMT

Dear Prashant,

It's work for column %

It's Okay

Thanks

Re: How to make expression with constant value base on dimension required ?

tresB — Wed, 14 Feb 2018 10:01:58 GMT

Yes, 'in this case'. But what if there were multiple values in LINI1 with 'PROD' JNS1 ? Sum() and Max() aren't same right? danipudianto‌ , please close the thread by marking correct/helpful the right replies.

Re: How to make expression with constant value base on dimension required ?

PrashantSangle — Wed, 14 Feb 2018 10:23:48 GMT

Yes you are correct Tresesco. when there are multiple values for LINI1 with PROD JNS1 then sum() and max() will evaluate differently

Solution will completely depends on how user want the data..