Bug or My Mistake?

[tamilarasu]

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

[jagan]

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.

[tamilarasu]

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

[jpenuliar]

Hi Tamil,

What SR version are you using?

[tamilarasu]

Hi Jonathan,

See this

[hic]

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

[tamilarasu]

Hi Henric,

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

Set modifier problem with empty column