Solved: whats wrong with this expression - Qlik Community - 381548

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

it says error in this expression, but I don't know why:

if(Keynumber='Orders',count(order_id),

if(Keynumber='Revenue',sum(amount),

if(Keynumber='Conversion',sum(first),

if(Keynumber='New Users',count(DISTINCT(user_id),

if(Keynumber='New Subscriptions',sum(new)-sum(cancelled)))))))

1 Solution

Accepted Solutions

Hi

I think you need:

if(Keynumber='Orders',count(order_id),

if(Keynumber='Revenue',sum(amount),

if(Keynumber='Conversion',sum(first),

if(Keynumber='New Users',count(DISTINCT user_id),

if(Keynumber='New Subscriptions',sum(new)-sum(cancelled))))))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

1 Reply

Hi

I think you need:

if(Keynumber='Orders',count(order_id),

if(Keynumber='Revenue',sum(amount),

if(Keynumber='Conversion',sum(first),

if(Keynumber='New Users',count(DISTINCT user_id),

if(Keynumber='New Subscriptions',sum(new)-sum(cancelled))))))

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein