Help with Set Analysis

[hopkinsc]

Hi,

I need to write an expression to show: sum(SalesQuantity) but to ignore a dimension (PriceOverride). I have not not a clue how to write this, can anyone help please?

Thanks

Chris

[#2]

if you mean a selection in the field PriceOverride, then:

sum({<PriceOverride=>} SalesQuantity)

[hopkinsc]

Hi nick,

No, i mean to ignore the dimension completely. Basically i have a calculated dimension which is hidden, so the user cannot select it anyway. The dimension is written to only display PriceOverrides which = yes, then i have ticked the 'Supress When Value is Null' option. I need to show sales no matter what the PriceOverride is equal to, so that is why i need an expression to completely ignore that dimension.

Thanks

[#4]

You cannot ignore a dimension in a chart. There is a possibility to sum(total <fields>). Or you can Show Partial Sums for the dimension PriceOverride if you use Pivot Chart.

[hopkinsc]

Hi Nick,

No that won't work for me as it shows the sum of salesquantity or ALL customers instead of seperating them.

In QLIKVIEW help - Set analysis, there is an expression which returns total sales within the application, disregarding both selection and dimension. sum( {1} Total Sales )

So if ALL dimesions can be ignored, surely there is a way to only ignore one dimension??

[pover]

Chris,

I think it would be helpful to upload a small sample of what you're working on in a QlikView file with a excel table of the result you want because you've been battling with this for a couple days and nobody seems to completely understand the problem to help you.

Regards.

[hopkinsc]

Here is a sample...

Thanks

[johnw]

Replace your calculated price override dimension with field PriceOverride. Change expressions to these:

if(PriceOverride='yes',sum({<LineType-={'V'}>} [Reduced Quantity]))
if(PriceOverride='yes',(CurrentRSP-ItemPrice)*Sum(SalesQuantity))
if(PriceOverride='yes',sum({<LineType-={'V'}>} total <Customer> SalesQuantity ))

[hopkinsc]

John, thanks for your reply. How would i then only display PriceOvverrides =yes? I don't want to display any of the PriceOverrides=no.

This part of the app i am writing is for Reduced to Clear sales, so when the user maximises the Reduced to Clear chart i only want it to display Reduced to Clear sales without having the user to make selections.

But i still need ALL sales to be loaded in, as other charts in this app will relate to different sales.

Thanks

[johnw]

Since none of the expressions above will return a value for a PriceOverrride='no', then the default suppression of nulls should remove those rows.