topic Re: Bug or My Mistake? in QlikView

Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 05:21:33 GMT

Hi,

I am new to qlikview. I found a weird problem while working on a file. I have used set expression "Count({<Status={'F'}>}Cust)" to display the count of customer where the status is "F". When I tried, I got customer count. But the column is blank. I have tried to load the data from inline, this time the result is correct. I can use if condition but I want to know why this has occurred.

Attached QVW sample file and data.

Thank you.

Kind Regards,

Tamil

Re: Bug or My Mistake?

hic — Thu, 05 Mar 2015 07:19:05 GMT

The field Status is blank in your data. Maybe you want to use

Count({<Prod={'F'}>} Cust)

instead?

HIC

Re: Bug or My Mistake?

anbu1984 — Thu, 05 Mar 2015 07:27:30 GMT

Count(If(Status='F',Cust))

Re: Bug or My Mistake?

jagan — Thu, 05 Mar 2015 08:12:31 GMT

Hi Nagaraj,

All your Status field values are null that is why you are not getting values, check whether you are using correct status field?

or you can use

=Count(Cust)

Regards,

Jagan.

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 08:16:20 GMT

Hi Henric,

This is mock data. Field name is correct and the column might be filled with letters like 'F' or 'D'. For example if i enter F in column the output is displayed correctly.

Sometime the column might be blank. In that case, set expression failed to display the result correctly (Showing all customers, but it should not display any results. ). Could you correct me, If I am wrong.

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 08:18:22 GMT

Hi Jagan,

Yes. Sometimes, status field might not filled with any values. If i enter 'F' in column the output is displayed correctly. See above screenshot. If there is no data in column status, it should not display any results right?

Re: Bug or My Mistake?

jagan — Thu, 05 Mar 2015 08:22:49 GMT

Hi,

Try like this

CustData:

LOAD Sno,

Cust,

Prod,

Alt(Status, '') AS Status,

[Sold Qty],

Price

FROM

Sample.xlsx

(ooxml, embedded labels, table is Sheet1);

Now it will show correctly, seems there is issue with field will all Null values from Excel in Set analysis.

Regards,

Jagan.

Re: Bug or My Mistake?

Peter_Cammaert — Thu, 05 Mar 2015 08:28:10 GMT

Does it have something to do with the fact that count(No Data) returns NULL instead of 0?

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 09:12:24 GMT

Hi Jagan,

I have entered some values manually. This time no values has been uploaded in status filed. The solution which given by anbu chelian is working fine. But my question is whether there is a bug in set analysis or not.? I came across the scenario already. I just want to know, everyone else is facing the same issue.

Hope I clearly explained my doubt!

Thank you for your response.

Re: Bug or My Mistake?

simenkg — Thu, 05 Mar 2015 09:19:19 GMT

I believe this came up few months ago as well, and that this was a bug in the way Set Analysis worked on fields with only null()-values.

Found it:
Set modifier problem with empty column

Re: Bug or My Mistake?

jagan — Thu, 05 Mar 2015 09:25:33 GMT

Hi Nagraj,

With Inline it is working fine, I think the issue is with Excel file I think. hic please check this issue.

Regards,

Jagan.

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 09:28:02 GMT

Thank you Simen. I just want to inform about this to you all.

Re: Bug or My Mistake?

jpenuliar — Thu, 05 Mar 2015 09:33:25 GMT

Hi Tamil,

What SR version are you using?

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 09:36:51 GMT

Hi Jonathan,

See this

Re: Bug or My Mistake?

hic — Thu, 05 Mar 2015 09:41:18 GMT

An inline does not create any NULL values. But the excel sheet does. So the difference in behaviour may still be correct.

If you have an example that you still think shows an erroneous behaviour, please post it.

HIC

Re: Bug or My Mistake?

tamilarasu — Thu, 05 Mar 2015 09:45:26 GMT

Hi Henric,

Please see this thread. Someone have already posted the same scenario.

Set modifier problem with empty column