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: 
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:)

5 Replies
robert_mika
Master III
Master III

Not applicable

hi,

whether you want to ignore all the field selections.

avinashelite

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