topic Re: GetFieldSelections + SetAnalisys in QlikView

GetFieldSelections + SetAnalisys

ilanbaruch — Sun, 06 Sep 2015 15:46:02 GMT

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

robert_mika — Sun, 06 Sep 2015 20:28:18 GMT

Look here

Mon, 07 Sep 2015 06:05:02 GMT

hi,

whether you want to ignore all the field selections.

avinashelite — Mon, 07 Sep 2015 07:56:56 GMT

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

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

CompanyName)>} Sales)

sasiparupudi1 — Mon, 07 Sep 2015 08:08:57 GMT

you can use 1-$

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

hth

Sasi

jagan — Mon, 07 Sep 2015 14:40:39 GMT

Hi,

Attach some sample file and explain what you want exactly.

Please check below link to get answers faster.