topic Re: Re: Need to count data in QlikView

Need to count data

Wed, 12 Nov 2014 21:12:15 GMT

Hi Everyone,

I m new to Qlikview.

i have a excel file with two sheets(sheet A & B) both having same field. I joined it using Left Join.

Now i want to know the count of the field Quote in sheet A.

Re: Need to count data

Anonymous — Wed, 12 Nov 2014 21:24:19 GMT

In your load script, add a Field "Source" or something like that so you can use an expression like:

count({$<Source={'A'}>}Quote)

Re: Need to count data

maxgro — Wed, 12 Nov 2014 22:15:36 GMT

see attachment

Re: Need to count data

Thu, 13 Nov 2014 04:48:07 GMT

How do we add a new field

Load

XYZ,

Simply Like this ?

Re: Need to count data

Thu, 13 Nov 2014 09:25:27 GMT

I m using the personal Edition i cannot open the attachment

Could you please share the script

Re: Re: Need to count data

ashfaq_haseeb — Thu, 13 Nov 2014 09:49:10 GMT

Hi,

Script





Table:
LOAD Quote, '1' as Sheet
FROM Book1.xlsx (ooxml, embedded labels, table is A);


Concatenate
LOAD Quote, '2' as Sheet
FROM Book1.xlsx (ooxml, embedded labels, table is B);

New chat straight table

No Dimension just write 3 Expression

Expression1:

count(Quote)

Expression2:

count({<Sheet={1}>} Quote)

Expression3:

count({<Sheet={2}>} Quote)

Regards

ASHFAQ