Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kira_whopper
Creator
Creator

Pivot table expression selector with inline table

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:

target.png

And this is what I get:

current.png

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):

inline.png

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

Thanks in advance!

0 Replies