Loading data from excel

[#1]

Hi,

I have a excel sheet which contains below information. when I am trying to create a Pivot chart I am getting Count of Label as 5 which is correct but for Bond and fee how can I get the count 2 instead of 5. Could anyone help me how to populate this

Name	Label	Bond	Fee
sales	pass	pass
crest	fail	fail	pass
Accounts	fail		fail
CEO	pass
Development	pass

Thanks.

[michael_maeuser]

you need to do count(distinct ...)

[#3]

Could you tell me a bit more clear how to use if possible please send me the expression so that would be helpful to me.

Thanks.

[vikasmahajan]

hII

Find attachment of qvw , Will possible in Straight table only not in pivot.

[michael_maeuser]

it also works this way in pivot table, but it´s the same result and more complex...

[#6]

Thanks for this and actually I have count of label as 5 and count of Baon and Fee as 2 in the excel sheet that it is ignoring blanks in the very same manner if I need to get the count of records in chart how can I do it. Could you please help me.

Thanks.

[sparur]

not so clear understandable what do you try to achieve,

Where do you need count ? by the expression (as an additional column), in the total row or something else?

could you specify your task please?

[vikasmahajan]

You can achieve the same by using straight table only.

Vikas

[#9]

Hi,

Actually I have the above table in excel spread sheet and I have another sheet in the same excel workbook. In the second sheet I have the count of Label as 5 and the count of Bond=2 and Fee=2. but when I am loding in to qlikview application the count is showing as

Label=5

Bond=5

Fee=5

but I want the output as

Label=5

Bond=2

Fee=2

Could you help me in this.

Thanks.

[ashwanin]

use the same expression as you are putting for Label

ie. =count(Bond) .

rgds Ashwani