topic summing logic request for a particular development. in QlikView

summing logic request for a particular development.

hosasahana — Wed, 06 Jan 2021 11:12:54 GMT

hi all,

I have a data set in which we have below 5 columns. Column A,B,C and D has multiple values for multiple dates. I am trying to sum up the column C referring the column B specially for each date .

If B has single value for each date --> D=C

If B has duplicates for same date-->D should be sum of both the corresponding C value.

Below eg: the yellow marked D value should actually be 36 in both rows.(C=18,C=18)

how can we achieve this? Please can someone help me?

Re: summing logic request for a particular development.

Chanty4u — Wed, 06 Jan 2021 11:18:02 GMT

what is your measure?

you can try

aggr(yourmeasure),dim)

Re: summing logic request for a particular development.

Anil_Babu_Samineni — Wed, 06 Jan 2021 11:24:38 GMT

You specially, no need to do since Qlik has capable to do by default, But in your case seems not working? Can you check once how is your measure looks like?

Try this and see the length : Len(B)

also measure you can try this way : Sum(TOTAL <B> Measure)

Re: summing logic request for a particular development.

hosasahana — Wed, 06 Jan 2021 11:28:06 GMT

hi,

My measure is sum (C) which will go into D column to both duplicate rows. grouping should happen on Column B.

I tried aggr(yourmeasure),dim), doesnt work.

Re: summing logic request for a particular development.

Anil_Babu_Samineni — Wed, 06 Jan 2021 11:34:17 GMT

Check once Len(B) and confirm, If looks good? This is required some workaroung to tune on this with the combination of Trim(), Text() etc.

Re: summing logic request for a particular development.

hosasahana — Wed, 06 Jan 2021 14:16:00 GMT

hi Anil,

I do not need len function here. I tried with aggr and it worked.

thanks a lot for your time .

Re: summing logic request for a particular development.

Anil_Babu_Samineni — Wed, 06 Jan 2021 15:15:47 GMT

Glad you made it work, Close this thread by accept the answer yourself with resolution.