Qlik logic not working

[subba5511]

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

[ajaykakkar93]

hi,

can you sharew a sample data in csv so can take a look 

[wilsonwebbe]

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.