topic Re: count syntax problems in QlikView

count syntax problems

Fri, 10 Feb 2017 10:48:59 GMT

Hello there

hope to place my question on the right place.....

I've got this expression wich doesn't work on a normal text field....

num(100 *(count({<ZeitIst <= {ZeitSoll},Prozessnummer ={'P2'}>}Prozessnummer)) /

(count({<Ende -= {'Null()'},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

it works (Syntax check) when I canche it to:

num(100 *(count({<ZeitIst = {ZeitSoll},Prozessnummer ={'P2'}>}Prozessnummer)) /

(count({<Ende -= {'Null()'},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

(it looks like I am using the wrong Operator <= for smaller equal).

any one an idea?

Thanks for your help

Re: count syntax problems

sdmech81 — Fri, 10 Feb 2017 12:18:51 GMT

May be like

ZeitIst = {'<=ZeitSoll'}

Your less than equal should go inside {}

Sachin.

Re: count syntax problems

Anil_Babu_Samineni — Fri, 10 Feb 2017 12:19:38 GMT

Try this and Can you describe more, What are these?

Try to do it in script

Load *,

%LaufnummerID & %ProzessID as %LaufProzID;

And then Use this as Expression

Num((Count({<ZeitIst = {"<ZeitSoll"}, Prozessnummer = {'P2'}>} Prozessnummer))/

(count({<Ende -= {' '}, Prozessnummer ={'P2'}>} %LaufProzID)) * 100,'#,#0%')

Re: count syntax problems

Fri, 10 Feb 2017 22:12:52 GMT

Thank you very much for your help.

I will it try as soon as possible....

Re: count syntax problems

rubenmarin — Sat, 11 Feb 2017 00:46:47 GMT

Hi, maybe:

num(100 *(count({<ZeitIst = {"<=ZeitSoll"},Prozessnummer ={'P2'}>}Prozessnummer)) /

(count({<Ende = {"*"},Prozessnummer ={'P2'}>}%LaufnummerID&%ProzessID) ),0.00) &'%'

The "<=" maybe should be an "<". And using double quotes the evaluate the condition.

The "*" is in case you want to filter all fields with any value not null(), if you are looking to remove the string 'Null()' keep your original "Ende -= {'Null()'}".

Also it will be a good idea what Anil posted about loading the field in script.

Re: count syntax problems

Fri, 24 Feb 2017 09:49:23 GMT

Dear all

Thank you very much for your respond. I solved because of you the Syntax issue and it worked.

sincerly Danny