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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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