topic Re: Concat values for only flag with minimum value in QlikView

Concat values for only flag with minimum value

kushalthakral — Sat, 03 Apr 2021 05:12:15 GMT

Hi All

i have a requirement where i need to concat values where we have minimum flag associated with the Id values like in below table

For Id A, i have two values one for flg 1 and one flg 2, in case of Id B i have only one value of flg i.e 2

So i need to concat A1,B1 and C1 based on minimum values of flag for associated Id's

I hope my question is making sense

Thanks in advance

Kushal

rubenmarin — Sun, 04 Apr 2021 17:09:52 GMT

Hi, if possible i would flag the min values of each id in script so you only need:

Concat({<MinFlag={1}>} [Sub ID])

If not I think you will need an aggr and an if, like: =concat(Aggr(If(Flg=Min(TOTAL <Id> Flg), [Sub ID]),Id,Flg) ,',')

kushalthakral — Sun, 04 Apr 2021 17:44:11 GMT

Thanks, that is what I was looking for

Thanks for your efforts and Help

Cheers

Kushal