Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Surya
Creator II
Creator II

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
sunny_talwar


@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
Creator II
Creator II
Author

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)

sunny_talwar

okay, so what is wrong 🙂

Surya
Creator II
Creator II
Author

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