Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

count expression in back end script

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

 

 

 

 

12 Replies
Highlighted
Creator II
Creator II

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.

Highlighted
Creator II
Creator II

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

Creator II
Creator II

hi,

 

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

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

View solution in original post