topic Re: Problem with Dimension Limits in QlikView

Problem with Dimension Limits

Tue, 16 Dec 2014 09:25:04 GMT

Hi Gurus,

I have a straight table with the dimensions ModelCode, ItemCode and Measure as Sales Amount, Sales Quantity. I have applied dimension limit on ModelCode to display only those model codes that are contributing to 40% of the Total Sales Amount. This displays around 400 ModelCodes(this is what I want).

Now I add a new column to this table that is Last 4 Weeks Sales. What I expect to see is the last 4 week sales to be displayed only to the model codes that are contributing to the 40% of the Total Sales Amount(i. e. I am expecting that only 400 ModelCodes are displayed with three measures). But once I add a new column the number of model codes are getting increased.

Can anyone help me if I am missing something here?

Thank you.

Pramod

Re: Problem with Dimension Limits

maleksafa — Tue, 16 Dec 2014 09:29:36 GMT

did you check again the dimension limits tab to see if the order is still the same after adding the Last 4 weeks Sales expression? can you upload a sample document to check?

Re: Problem with Dimension Limits

saumyashah90 — Tue, 16 Dec 2014 09:32:23 GMT

You will have to use expression or edited dimension for that i guess .In this you will have to specify like

if(SalesAmount>='40%',ModelCode).