Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Surya
New Contributor III

Add calculated dimension expression problem

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

 

4 Replies

Re: Add calculated dimension expression problem


@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?

Surya
New Contributor III

Re: Add calculated dimension expression problem

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

okay, so what is wrong 🙂

Highlighted
Surya
New Contributor III

Re: Add calculated dimension expression problem

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