Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

sum 2 fields in 1 field in qlik view

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 ?




0 Replies