count expression in back end script

[dunnalahk123]

HI,

i am writing below in back end script qlikview.

load

count(Id) as project id ,

code

from

xxx.qvd

group by id,code

but i write above i am getting duplicate count  because one project id will have multiple codes so when i group by code project count is duplicating.

ex:

id    code

xxx   code1

xxx   code 2

xxx code 3

so  as project id is same i need count as only 1 not 3. 

so in front end report as well i am using code field so if some one select code as 3 count should be 1 or if some one select code 2 count should be 1 

so how can i write in back end script ?

best regards,

HK

[dunnalahk123]

hi,

its not a dashboard , its a scorecard and i have almost 50 kpi's in that.

front end we have everything designed like it will have numerator \ denominator if its percentage.

if its numerical value it will have just count of numvalue or sum of num value depends on kpi.

so everything i am getting formatted at back end.

[dunnalahk123]

any idea pereira how can we bring [project id flag] field to front end   ?

[dunnalahk123 · Accepted solution]

hi,

i wrote like this and it works perfectly . what i need.

If(Exists([Project ID]), 0, 1)