Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mambi
Contributor III

simple formula

hi everyone :

is there a better way  to write (simplify) this formula

sum({1<TRIM={'$(vMaxS1)','$(vMaxS2)'}>}[QTY])  /  sum( {1<TRIM={'$(vMaxS1)','$(vMaxS2)'}>} total <TRIM> [QTY])

thanks

Tags (1)
1 Reply
Not applicable

Re: simple formula

I don't think so.

You are using set Analysis .

Community Browser