Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
muniyandi
Contributor III

Direct Discovery: Expression Failed

Hi,

I am using direct discovery for my fact table.  using aggregate function and if condition that time failed the expression.

Ex:

Case 1  : Sum(Amount)  -- Working

Case 2  : if(REGION='ALL',Amount,0)  -- Working

Case 3  : Sum(if(REGION='ALL',Amount,0) ) -- Failed

How to solve the problem in case 3.

Thanks,

Muni.

Tags (1)
3 Replies
muniyandi
Contributor III

Re: Direct Discover: Expression Failling

Hi Experts,

pls , help for me.

sujeetsingh
Honored Contributor III

Re: Direct Discovery: Expression Failed

It should work

muniyandi
Contributor III

Re: Direct Discovery: Expression Failed

Hi Sujeet,

just try out in direct discovery method, it's not working.

Community Browser