topic Re: Sum calculation in QlikView

Sum calculation

mambi — Thu, 24 May 2018 11:05:49 GMT

Hi,

Please have a look at the qvw and xlsx files.

in the (qvw) summary chart i want to be able to display the sum of quantity when the recommended product was sold (only when flag = 1 )

the final chart (expected result) should be like the one in Sheet2 (xlsx file)

i tried with set analysis but no result.

any idea ?

sunny_talwar — Thu, 24 May 2018 11:12:59 GMT

May be do this using an Island Table approach or Link Table... I created it using Island table in the attached app.

mambi — Thu, 24 May 2018 11:26:50 GMT

Great work !

that's what i'm looking for,

but is there a way to do it with indirect set analysis only ?

Thanks a lot

sunny_talwar — Thu, 24 May 2018 11:28:43 GMT

Unfortunately, I don't think so...