Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bbongagus
Contributor II
Contributor II

Combining flags in SA

Hello, guys!
For example:

I have a variable

vSumOfSales = Sum($1 [Sales])

and some flags like:

fCMTD = {<[_CMTD_Flag] = {1}>} 

fClearProduct = {<[Product]=>}

and some more...

 

Is there a way to combine such flags to use in vSumOfSales like parameter? 

Thank you.

 

1 Solution

Accepted Solutions
sunny_talwar

You can try this may be

vSumOfSales = Sum({<$1, $2, $3, $4, $5, $6, $7>} [Sales])

you can include extra $... for additional parameters .and then use it like this

$(vSumOfSales([_CMTD_Flag] = {1}, [Product]))

 

View solution in original post

1 Reply
sunny_talwar

You can try this may be

vSumOfSales = Sum({<$1, $2, $3, $4, $5, $6, $7>} [Sales])

you can include extra $... for additional parameters .and then use it like this

$(vSumOfSales([_CMTD_Flag] = {1}, [Product]))