topic Re: Qlikview Count({< not working in QlikView

Qlikview Count({< not working

Mon, 06 Jul 2015 13:40:55 GMT

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,

Re: Qlikview Count({< not working

swuehl — Mon, 06 Jul 2015 15:37:57 GMT

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.

Re: Qlikview Count({< not working

sinanozdemir — Mon, 06 Jul 2015 15:45:37 GMT

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

Re: Qlikview Count({< not working

Anonymous — Mon, 06 Jul 2015 16:21:32 GMT

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?

Re: Qlikview Count({< not working

stigchel — Mon, 06 Jul 2015 16:45:51 GMT

Can you try with

Count({<

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

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

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 09:03:34 GMT

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

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 09:12:40 GMT

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

Re: Qlikview Count({< not working

krishna20 — Tue, 07 Jul 2015 09:26:25 GMT

Hi,

Try this

Count({<

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

Re: Qlikview Count({< not working

sunny_talwar — Tue, 07 Jul 2015 09:50:50 GMT

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

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 10:29:31 GMT

Yes, it is working.

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

The

SET Nullvalue = '';

NULLASVALUE *;

works .

Thanks again

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 10:31:20 GMT

Thanks

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 10:31:36 GMT

Thanks

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 10:34:00 GMT

How do I close this thread Sunindia?

Thanks,

Re: Qlikview Count({< not working

sunny_talwar — Tue, 07 Jul 2015 10:37:37 GMT

Click on Correct Answer for whomsoever's answer worked the best for you

Thank you for being prompt for my request.

Best,

Sunny

Re: Qlikview Count({< not working

Tue, 07 Jul 2015 10:52:43 GMT

Thank you