Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if you mean a selection in the field PriceOverride, then:
sum({<PriceOverride=>} SalesQuantity)
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
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.
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??
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.
Here is a sample...
Thanks
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 ))
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
Since none of the expressions above will return a value for a PriceOverrride='no', then the default suppression of nulls should remove those rows.