Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

set analysis with dimension

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)

1 Solution

Accepted Solutions
thomas_skariah
Contributor III

Re: set analysis with dimension

Hi,

Find the attached application.

Hope this works.

Regards,

Tom

6 Replies
whiteline
Honored Contributor II

Re: set analysis with dimension

I think the correct syntax is:

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

But it depend on the value of DIMENSION_FIELD_NAME variable.

Not applicable

Re: set analysis with dimension

It doesn't work.

The data is like this:

Table1:

PartNamePartCategoryPartValueWeekYear
Part1ABC2012012
Part2DEF1012012
Part3ABC10012012
Part4DEF9022012
Part5ABC8022012
Part6DEF9022012
Part7ABC8032012
Part8DEF2042012
Part9ABC2052012
Part10DEF1052012

Table2 :

PartCategoryBudgetWeekYear
ABC5012012
DEF5012012
ABC6022012
DEF6022012
ABC5132012
DEF5132012
ABC6142012
DEF6142012
ABC5252012
DEF5252012

And if 1 select week 2 i want to see:

PartCategorysumPartValueBudget
ABC8060
DEF18060
whiteline
Honored Contributor II

Re: set analysis with dimension

What is DIMENSION_FIELD_NAME ?

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

thomas_skariah
Contributor III

Re: set analysis with dimension

Hi,

Find the attached application.

Hope this works.

Regards,

Tom

Not applicable

Re: set analysis with dimension

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

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

Not applicable

Re: set analysis with dimension

Thanks everyone, it seems to work correctly

Community Browser