topic Re: set analysis with dimension in QlikView

set analysis with dimension

Mon, 03 Sep 2012 07:00:38 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)

whiteline — Mon, 03 Sep 2012 07:18:48 GMT

I think the correct syntax is:

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

But it depend on the value of DIMENSION_FIELD_NAME variable.

Mon, 03 Sep 2012 07:42:32 GMT

It doesn't work.

The data is like this:

Table1:

Table2 :

And if 1 select week 2 i want to see:

whiteline — Mon, 03 Sep 2012 07:47:42 GMT

What is DIMENSION_FIELD_NAME ?

Why not to use just Sum(Budget) as your tables are connected through PartCategory.

thomas_skariah — Mon, 03 Sep 2012 07:53:29 GMT

Hi,

Find the attached application.

Hope this works.

Regards,

Tom

Mon, 03 Sep 2012 07:53:46 GMT

Oh sorry, the 2 tables are only connected by week.

But I am going to try now to connect them by PartCategory.

Mon, 03 Sep 2012 08:17:57 GMT

Thanks everyone, it seems to work correctly