topic If Script in QlikView

If Script

Anonymous — Wed, 01 Jul 2015 14:10:42 GMT

Hi Everyone,

i am using the following script for pulling the data(count of name ) only for those which have status = Reopen or WIP

Count(if (Status ='Re-open'or 'WIP ' , Name, 0) )

But this script is not giving me the correct total.

Please assist

Re: If Script

Gysbert_Wassenaar — Wed, 01 Jul 2015 14:13:14 GMT

Try: Count({<Status={'Re-open','WIP '}>} Name)

And make sure if it's 'WIP' or 'WIP ' (with an extra trailing space after the P). They are two different values.

Re: If Script

Anonymous — Wed, 01 Jul 2015 14:13:17 GMT

Count(if (Status='Re-open') or (Status='WIP'), Name,0))

Re: If Script

Wed, 01 Jul 2015 14:16:23 GMT

Try this,

Count(Distinct(if(match(Status,'Reopen','WIP'),Name)))

Re: If Script

Gabriel — Wed, 01 Jul 2015 14:19:29 GMT

Hi,

Are you doing this logic in the script or UI.

If you are doing it in the script then use flag

here is an example

Data:

LOAD * , IF(Status = 'Complete',1,0) AS Status_Flag Inline
[
Currency ,      amount, Status
001,                1000,Complete
002,                1500, WIP
003,                1500,WIP
004, 2000, Complete
005,                1000,Complete
006 ,                500, Complete
];

And then in your chart use Set Analysis to count Status_Flag

Re: If Script

Anonymous — Wed, 01 Jul 2015 14:35:53 GMT

try!

Count({$<Status={'Re-open','WIP '}>} Name)

if (Status='Re-open' or Status='WIP', count(Name),0)

Regards!

Jannet

Re: If Script

pratap6699 — Wed, 01 Jul 2015 15:55:04 GMT

Count({<Status={'Re-open','WIP '}>} Name)

Re: If Script

Anonymous — Thu, 02 Jul 2015 05:15:28 GMT

Hi Jannet,

Thanx, finally its here !!!

Cheers..

Re: If Script

pratap6699 — Thu, 02 Jul 2015 07:00:53 GMT

in script level

if (Status='Re-open' or Status='WIP', count(Name),0)

Re: If Script

Anonymous — Thu, 02 Jul 2015 13:52:02 GMT

You welcome!! Guarav

Regards.