topic Please help me in QlikView

Please help me

Surya — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Please help me

jyothish8807 — Mon, 04 Feb 2019 07:07:15 GMT

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.

Re: Please help me

Surya — Mon, 04 Feb 2019 07:10:22 GMT

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

ok i changed to sms* i got the same.

Re: Please help me

jyothish8807 — Mon, 04 Feb 2019 07:39:20 GMT

Can you share a sample application with sample data ?