Discussion board where members can get started with Qlik Sense.
i am writing below in back end script qlikview.
count(Id) as project id ,
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.
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 ?
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 ?
i wrote like this and it works perfectly . what i need.
If(Exists([Project ID]), 0, 1)
View solution in original post