Need to count data

[#1]

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.

[Anonymous]

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

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

[maxgro]

see attachment

[#4]

How do we add a new field

Load

..

XYZ,

Simply Like this ?

[#5]

I m using the personal Edition i cannot open the attachment

Could you please share the script

[ashfaq_haseeb]

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