topic Re: Add calculated dimension expression problem in QlikView

Add calculated dimension expression problem

Surya — Sat, 16 Nov 2024 03:51:28 GMT

Hi,

in add calculated dimension i need

IF(WildMatch(BILL_PLANT ,'8502') AND WILDMATCH(MATERIAL_BILL_LONG ,'BL_*','RD_*'),'BARMILL/ROUND',
IF (WILDMATCH(PROD_PLANT,'8502') AND WILDMATCH(PROD_MVT_TYPE,'101','102') AND WILDMATCH(PROD_MATERIAL_LONG,'RD_*') AND WILDMATCH(PROD_MATERIAL_GROUP,'S001','S002'),'ROUND',
IF (WILDMATCH(PROD_PLANT,'8502') AND WILDMATCH(PROD_MVT_TYPE,'101','102') AND WILDMATCH(PROD_MATERIAL_LONG,'BL_*') AND WILDMATCH(PROD_MATERIAL_GROUP,'S001','S002'),'BILLET'))))

how can we do..?

i need individul and sum of both

Re: Add calculated dimension expression problem

sunny_talwar — Mon, 15 Apr 2019 11:35:16 GMT

@Surya wrote:
i need individul and sum of both

What exactly do you mean? Can you elaborate using a sample and expected output from the sample?

Re: Add calculated dimension expression problem

Surya — Mon, 15 Apr 2019 11:45:52 GMT

In add calculated dimension,

if(wildmatch(plant,'8502') and wildmatch(name,'bl_*'),'Bar' //value 02

if(wildmatch(plant,'8502') and wildmatch(name,'rd_*'),'round' //value 05

if(wildmatch(plant,'8502') and wildmatch(name,'rd_*','bl_*'),'bar/round' //value 07

)))

//in line chart

expression is sum(qty)

Re: Add calculated dimension expression problem

sunny_talwar — Mon, 15 Apr 2019 11:54:08 GMT

okay, so what is wrong 🙂

Re: Add calculated dimension expression problem

Surya — Mon, 15 Apr 2019 11:59:00 GMT

WHEN I USE LINE CHART IM GETTING BAR AND ROUND NOT GETTING BAR/ROUND BRO