Qlikview Count({< not working

[#1]

Hi All,

Please can you assist.

I have a QlikView dashboard reading from an Access database (Table that contains both April and May's file).

I then applied the following formula to a pivot table "

Count({<

[Turnover Trade Status]={'Amended','New'},

[Turnover Custody/FoP/FX]={''},

[Turnover Trade Type]-={'Position Transfer'}>}[Turnover Company])

with Dimensions Date.

However the formula does not calculate properly, it only calculates properly for the first month April and not May..

Many thanks,

[swuehl]

Hard to answer without knowing what you mean with 'not calculate properly'.

I think it would be best if you could upload a small sample QVW that demonstrates your issue.

[sinanozdemir · Accepted solution]

The only thing that I can think of is that the piece where you are filtering blank values; [Turnover Custody/FoP/FX]={''}.

They might not be blank, but NULL.

So try the below in your load script to see if it gets you the desired results.

SET Nullvalue = '';

NULLASVALUE *;

Thanks

[Anonymous]

Try to test ,taking a text box with this expression and use filters for the month and then try selecting the april month in the filter and then may?

Is this working?

[stigchel]

Can you try with

Count({<

[Turnover Trade Status]={'Amended','New'},

[Turnover Trade Type]-={'Position Transfer'}>-<[Turnover Custody/FoP/FX]={'*'}>} [Turnover Company])

[#6]

Thanks for the reply Piet but it doesnt work...

[#7]

Thanks for the reply Sinan, I think it is working, let me check first

[krishna20]

Hi,

Try this

Count({<

[Turnover Trade Status]={'Amended','New'},[Turnover Custody/FoP/FX]={''},[Turnover Trade Type]={'*'}-{'Position Transfer'}>}[Turnover Company])

[sunny_talwar]

If you got this to working, I would suggest closing this thread by marking the correct answer as well as marking any helpful answers.

Best,

Sunny

[#10]

Yes, it is working.

Qlikview was not recognising the null values hence no output in some cases.

The

SET Nullvalue = '';

NULLASVALUE *;

works .

Thanks again