Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

shows the data exclude from selection

hello everyone,

I have a task where I have to exclude selected data.

for example I have two tables like

production_item   production_year

A                              2011

B                              2010

C                              2008

D                              2009

Now I have to exclude item of selected year like

year.png

thank you in advance

1 Solution

Accepted Solutions
Not applicable

Here is an example of how you might handle that:

=if(isnull(GetFieldSelections(production_year))<>-1,Only({1-$} DISTINCT production_item), Only({$} DISTINCT production_item))

View solution in original post

25 Replies
its_anandrjs

Please elaborate more in chart you want this or in table load .

Not applicable

Use set.

e.g. if u want to get the count of production_item ignoring the selecting it is something like,

count({<production_year=>}production_item)

Nicole-Smith

You can use E() in the set analysis in your expression.

Example:

=sum({<production_year=E(production_year)>}Value)

bruno_montenegr
Creator III
Creator III

If what you want is to not show the grey items in the list box, you cam check "Hide Excluded" in its properties.

jagan
MVP & Luminary
MVP & Luminary

Hi Bhawna,

If you Year= in excludes/doesn't considers the selection of the Year field

count({<production_year=>}production_item)


or


count({<production_year={'*'}>}production_item)


Hope this what you expect, if you are not expecting this come up with a sample and expected results.


Regards,

Jagan.

Not applicable

Thanks to everyone for replying,but I didnt get the actual solution,

I have to show only those Production Item of that year which is not selected,means as I have selected 2008 and 2009,

then the chart must show production item of year 2010 and 2011,please help me out this

Not applicable

I used the sample table u provided and came up with this

=Only({<production_year={'*'}-{$(=GetFieldSelections(production_year))}>}production_item)

This should give you an idea of how to omit the selection and give the rest.

Please let me know.

Not applicable

What will GetFieldSelections() function do?

and this script doesnt show any result,no data is display.

Not applicable

it brings back the selected value of the field you specified. In this case it is production_year.I attached the sample that I used below.