# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Labels (3)

4 Replies
MVP

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

Highlighted
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)

MVP

## Re: Add calculated dimension expression problem

okay, so what is wrong 🙂

New Contributor III

## Re: Add calculated dimension expression problem

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