topic Re: Ignoring date dimension in QlikView

Ignoring date dimension

noman212 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I am using a pivot table.

From there , i am using 3 dimensions.

Re: Ignoring date dimension

rubenmarin — Mon, 31 Oct 2016 10:23:25 GMT

Hi Noman, can you try using 'TOTAL'?:

SUM(TOTAL {<[Order Date],Day=,Flag={'SalesTarget'}>} Target_Cartons)

TOTAL is used to ignore chart dimensions but the selections still have effect. You can add fields to tell QV how to totalize but this has to fit with chart dimensions in a logical way:

SUM(TOTAL <jory> ....)

Re: Ignoring date dimension

noman212 — Mon, 31 Oct 2016 10:24:54 GMT

Thanks for your replyRuben.

Yes I tried but it return sum of field.

In sku field data is present in breakup this expression ignore the breakup value and club all sku in total.

Re: Ignoring date dimension

rubenmarin — Mon, 31 Oct 2016 10:30:13 GMT

Not sure to have understood this but... you tried also to set fields in TOTAL?, like:

SUM(TOTAL <jory, PAYSOFT_CODE, SKU> {<[Order Date],Day=,Flag={'SalesTarget'}>} Target_Cartons)

If not please give me more details about what you want and where you're stuck... my english is very limited, I can be more helpfull with a sample to work.

Re: Ignoring date dimension

noman212 — Mon, 31 Oct 2016 10:39:42 GMT

Thanks a lot that's what i want.