topic Re: set analysis with dimension in QlikView

set analysis with dimension

Thu, 30 Aug 2012 10:09:19 GMT

Hi,

I have a table with all the parts and as dimension the catergory of the parts and as expression the sum of the price of the parts.

Now I want to add an excel with expected sale sum per catergory.

I tried this:

sum( {$<CATERGORY= {"='${DIMENSION_FIELD_NAME}'"} >} EXPECTED_SALES)

Thu, 30 Aug 2012 12:13:50 GMT

This works;

sum( if(CATERGORY= DIMENSION_FIELD_NAME, EXPECTED_SALES))

But it seems it's ignoring the selection so I get the total expected sales per catergory.

And when I add something after it like: AND SALES_WEEK = SELCTED_WEEK

It has no effect