topic Re: Loading data from excel in QlikView

Loading data from excel

Wed, 21 Aug 2013 09:51:08 GMT

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.

Re: Loading data from excel

michael_maeuser — Wed, 21 Aug 2013 09:53:08 GMT

you need to do count(distinct ...)

Re: Loading data from excel

Wed, 21 Aug 2013 09:57:11 GMT

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.

Re: Loading data from excel

vikasmahajan — Wed, 21 Aug 2013 09:58:12 GMT

hII

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

Re: Re: Loading data from excel

michael_maeuser — Wed, 21 Aug 2013 10:04:40 GMT

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

Re: Loading data from excel

Wed, 21 Aug 2013 10:06:25 GMT

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.

Re: Loading data from excel

sparur — Wed, 21 Aug 2013 10:11:23 GMT

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?

Re: Loading data from excel

vikasmahajan — Wed, 21 Aug 2013 10:17:04 GMT

You can achieve the same by using straight table only.

Vikas

Re: Loading data from excel

Wed, 21 Aug 2013 10:18:27 GMT

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.

Re: Loading data from excel

ashwanin — Wed, 21 Aug 2013 10:27:40 GMT

use the same expression as you are putting for Label

ie. =count(Bond) .

rgds Ashwani

Re: Loading data from excel

er_mohit — Wed, 21 Aug 2013 10:33:49 GMT

Seethe attached file

Re: Loading data from excel

sparur — Wed, 21 Aug 2013 10:47:20 GMT

Could you provide your qvw example?