topic Conditional Whiskers? in QlikView

Conditional Whiskers?

Anonymous — Wed, 06 Apr 2011 22:05:26 GMT

The application is meant to show the user how Sales have behaved with relation to their respective Quotas.

In a List Box I want to include a Mini Chart that with Red-Blue whiskers - the Dimension is YearMonth - and I want a Red whisker to appear when the sales for that month were below the qouta, and a Blue whisker to appear when the sales for that month were equal or above the quota. It seems to me that an If-Else expression would do the trick, can anyone help me with the syntax and where to construct the expression?

Please see the 2 images of what I'm dealing with.

Does anyone know what I should do? Thanks for your response!

Conditional Whiskers?

rbecher — Thu, 07 Apr 2011 00:50:55 GMT

Mike,

maybe it's just that easy:

=if(sales>0, 1, 0)

And then configure the minichart like this:

- Ralf

Conditional Whiskers?

Anonymous — Thu, 07 Apr 2011 16:42:43 GMT

Thanks Ralf, good idea.

Conditional Whiskers?

rbecher — Thu, 07 Apr 2011 20:25:24 GMT

Mike, let me know if this is working for you.

- Ralf

Conditional Whiskers?

Anonymous — Fri, 08 Apr 2011 03:14:46 GMT

Thanks alot Ralf -

It's working for me now, but there was no need to me to put the IFstatement because the whiskers chart has a conditional clause built into it by definition, so I guess it was redundant. All I had to do was define my expression ; = sum(sales) - sum(quota). When that resulted in a positve number, a blue whisker appeared for the month, when negative it turned out red.

All the best,

Mike