Pivot table expression selector with inline table

kira_whopper — Mon, 03 Jul 2017 15:07:04 GMT

Hi there,

I'm trying to improve the performance of a QlikView application on a table chart where there are to many conditional expressions. To do that I'm tring to create an Inline table with the expressions on it, so that they could consider the expressions directly from it.

My issue is that the expressions doesn't work unless I select the field corresponding to it, as follows:

This is what I want to see:

And this is what I get:

My idea is to use the inline table to separate each KPI into period blocks, to reduce the number of conditionals currently being used in the original application. Where today I have "Sale", I'll also have "Growth", "Share", etc., each one below its respective Period (Sale MTH, Sale RQTR, Sale YTD, Sale MAT and so on):

Following attached is the xls and qvw I used to create this example.

Thanks in advance!

topic Pivot table expression selector with inline table in QlikView

Pivot table expression selector with inline table