topic 'Total' field in QlikView

'Total' field

Sat, 27 Dec 2014 09:05:37 GMT

Hi all ,

I got Total as extra field in 3 excel sheets, while doing aggregation functions I am not getting correct results ,because of Total as a field .How to avoid it .Plz help.

Thank you.

Re: 'Total' field

Gysbert_Wassenaar — Sat, 27 Dec 2014 09:13:43 GMT

Rename the field so every sheet total gets a unique field name.

Re: 'Total' field

its_anandrjs — Sat, 27 Dec 2014 09:26:30 GMT

Hi,

In expression you can use it like

[Total] or "Total"

Better you rename it.

Regards

Anand

Re: 'Total' field

Sat, 27 Dec 2014 09:31:14 GMT

Hi Gysbert,

FYI , I have data like this

category dt cr varience tax amount

hm1 20 10 50% .6% 100

hm2 30 10 45% .6 % 120

hm3 40 20 50% .6% 130

Total 350

Sorry I mentioned Total as field in my question , actually it is not. can you help me to take that 'Total' row out .

Thank you.

Re: 'Total' field

Gysbert_Wassenaar — Sat, 27 Dec 2014 09:36:31 GMT

Use a where clause:

MyData

LOAD * from MyXLFiles*.xlsx (ooxml, embedded labels, table is Sheet1)

WHERE category <> 'Total'

;

Re: 'Total' field

Sat, 27 Dec 2014 09:45:04 GMT

Hi Anand,

Can you say in detail..

Re: 'Total' field

Sat, 27 Dec 2014 09:46:41 GMT

Hi Gysbert,

Do i Need to use , Where Not Exist function here....

Re: 'Total' field

Gysbert_Wassenaar — Sat, 27 Dec 2014 10:00:17 GMT

No.