Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
Surya
New Contributor III

Please help me

I can replace value like below but its not working ..

individually all logic corect but i write with in its not working..

 

i write this logic in expression

..IF(WildMatch(PROD_PRODUCT_GROUP_NEW_USER,'SMS ') ,
IF(IF(WildMatch(SUMMARY_PARTICULARS,'SEMIS  TOTAL'),SUMMARY_PARTICULARS),
IF(FLAG_PROD = 'Y',
SUM({<FORECAST_MONTH_PROD_NEW = {'$(vSelectedMonth)'}>}FORECAST_VALUE_PROD_NEW),
SUM({<FORECAST_MONTH_PROD = {'$(vSelectedMonth)'}>}IF( WILDMATCH(SUMMARY_PARTICULARS,'*TOTAL*'),FORECAST_VALUE_PROD) ) ))


,IF(FLAG_PROD = 'Y',
SUM({<FORECAST_MONTH_PROD_NEW = {'$(vSelectedMonth)'}>}FORECAST_VALUE_PROD_NEW),
SUM({<FORECAST_MONTH_PROD = {'$(vSelectedMonth)'}>}IF(NOT WILDMATCH(SUMMARY_PARTICULARS,'*TOTAL*'),FORECAST_VALUE_PROD) ) ))

 

3 Replies
jyothish8807
Honored Contributor II

Re: Please help me

Hi Prakash,

Try changing the first line like this:

IF(WildMatch(PROD_PRODUCT_GROUP_NEW_USER,'SMS*'

Else please share some sample data to validate the expression.

Best Regards,
KC
Surya
New Contributor III

Re: Please help me

Thank you for your response but that name is exactly sms,

ok i changed to sms* i got the same.

jyothish8807
Honored Contributor II

Re: Please help me

Can you share a sample application with sample data ?

Best Regards,
KC