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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

GetFieldSelections + SetAnalisys

Hi All,

trying to exclude from expression user current selection with GetFieldSelections ,

also I tried to set a variable with  GetFieldSelections and to exclude variable with set set analysis

any suggestions will be appreciated:)

Labels (1)
5 Replies
robert_mika
MVP
MVP

Not applicable

hi,

whether you want to ignore all the field selections.

avinashelite
MVP
MVP

you can try with E() function...try like:

sum({$<CompanyName = E({$<CategoryName={"=getfeildselection(CategoryName,',')"}>}

CompanyName)>} Sales)

sasiparupudi1
Master III
Master III

you can use 1-$

sum( {1-$} Sales )
returns sales for everything excluded by the current selection.

hth

Sasi

jagan
Partner - Champion III
Partner - Champion III

Hi,

Attach some sample file and explain what you want exactly. 

Please check below link to get answers faster.

Qlik Community Tip: Posting Successful Discussion Threads