topic Re: Creating an inline table and trying to do some what if analysis in QlikView

Creating an inline table and trying to do some what if analysis

Mon, 29 Sep 2014 14:36:48 GMT

Hi, i just have read this article and im trying to do what if analysis with an inline table. Im talking about the article given in this thread what if. I know it´s weird but it´s a little example to understaund the concept, but i would like to know if this is right.

Thank you!

Re: Creating an inline table and trying to do some what if analysis

JonnyPoole — Mon, 29 Sep 2014 15:39:33 GMT

Looks good.

You can show % signs in the slider by adjusting the formatting of the slider as attached and then adjusting the multiplier in the straight table expressions by removing /100.

Consider using 'background color' property of each expression in the chart properties. On the expression tab, hit '+' next to the expression to view the background color

you could write something like this to show green or red depending if the what if # is higher or lower than the actual #:

if ( [Actual Avg Sales] * (1 + vSales2) > [Actual Avg Sales] , green(), if ( [Actual Avg Sales] * (1 + vSales2) = [Actual Avg Sales] , black(), red()))

Re: Creating an inline table and trying to do some what if analysis

Mon, 29 Sep 2014 16:18:31 GMT

Thank you, I found strange that there are only a fews examples of what if analysis, and i didnt found nothing simple with inline tables.

Cheers!

Re: Creating an inline table and trying to do some what if analysis

JonnyPoole — Mon, 29 Sep 2014 16:21:49 GMT

check out the demo sample QVW here: specifically the 'Sales Analysis' tab -> 'What If'

QlikView

Re: Creating an inline table and trying to do some what if analysis

Mon, 29 Sep 2014 18:05:48 GMT

Thanks!