Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
i have fields like Key, Program, Month, Year, Partno
i want to show more than one program part no's monthly.
exp: if i click on partno required only overlapping more than 1 program partno data.
applied below logic
=if(
sum(total Aggr(Count(distinct Program),Key,Program,Month,Year,Partno))
>1,1,0)
this logic showing correct values in qlik but when i download monthly data coming 0 values data into 1 values data in excel.
is there any way to use backend.
thanks in advance
Regards,
Subba
I would suggest you do the aggregation in the back end, then do a preceding load to add the flag of 1 or 0.
In the front end, you calculation becomes sum(FLAG). you can then either add an aggregation according to your preference.