Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
any idea pereira how can we bring [project id flag] field to front end ?
hi,
i wrote like this and it works perfectly . what i need.
If(Exists([Project ID]), 0, 1)