Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi best QV Community,
I’ve been using QlikView now for few months very smoothly.I thought this was a straight forward task but my limited knowledge proved that I was wrong.
i need to sum 2 different field in just 1 and delete the first one.
i used this script function but he doesn't work
=if(WildMatch(Treatment,'variable1','Variable2'),Sum({<Treatment={'Variable1'}>}[Sales Qty])=Sum({<Treatment={'Variable1'}>}[Sales Qty]) + Sum({<Treatment={'Variable2'}>}[Sales Qty]),
Sum([Sales Qty]))
i want to sum 2 variable in one fields with the same name like in this photo
you can find attached an excel file as example for what i want do it ?