topic Re: shows the data exclude from selection in QlikView

shows the data exclude from selection

Mon, 02 Jun 2014 18:40:18 GMT

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

thank you in advance

Re: shows the data exclude from selection

its_anandrjs — Mon, 02 Jun 2014 18:45:37 GMT

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

Re: shows the data exclude from selection

Mon, 02 Jun 2014 18:45:58 GMT

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)

Re: shows the data exclude from selection

Nicole-Smith — Mon, 02 Jun 2014 18:47:10 GMT

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

Example:

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

Re: shows the data exclude from selection

Anonymous — Tue, 03 Jun 2014 01:30:23 GMT

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

Re: shows the data exclude from selection

jagan — Tue, 03 Jun 2014 01:55:02 GMT

Hi Bhawna,

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

count({<production_year=>}production_item)

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.

Re: shows the data exclude from selection

Tue, 03 Jun 2014 13:09:05 GMT

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

Re: shows the data exclude from selection

Tue, 03 Jun 2014 13:35:24 GMT

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.

Re: shows the data exclude from selection

Tue, 03 Jun 2014 13:42:45 GMT

What will GetFieldSelections() function do?

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

Re: shows the data exclude from selection

Tue, 03 Jun 2014 13:53:40 GMT

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.

Re: shows the data exclude from selection

satishkurra — Tue, 03 Jun 2014 13:54:05 GMT

Sum({<Year-=2008>}Sales)

With the above expression it will exceed the 2008

For inclusion use + in place of - in above expression

Thanks

Satish

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:03:26 GMT

Another possible solution...

I created a list box using the production_year and a straight table with the following:

Dimension: production_year

Expression: =Only({1-$} DISTINCT production_item)

{1-$} will return results for everything excluded by the current selections

Hope this helps!

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:04:04 GMT

But it doesnt work for multiple selection the GetFieldSelections() does not take multiple selection inputs

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:07:33 GMT

But if I havent select any value it doesnt display any result.. No data is displaying.

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:10:04 GMT

Do you have another selection beside the production year? Then you have to give me the correct sample to help you out here.

Re: Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:16:04 GMT

Also it does work with multiple selection. You have to include your another selection with comma.

e.g.: =Only({<production_year={'*'}-{$(=GetFieldSelections(production_year))},t={'*'}-{$(=GetFieldSelections(t))}>}production_item)

Please check the attached.

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:19:18 GMT

No I have only two Fields,one

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:23:50 GMT

I really did not understand what your requirements are . Can you please post your sample file and state your needS?

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:24:16 GMT

That means as the number of selection increases I have to add GetFiealdSelection() for each?

Re: shows the data exclude from selection

Tue, 03 Jun 2014 14:26:24 GMT

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