Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 Reply
Not applicable

Re: set analysis with dimension

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

Community Browser