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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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]))