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

25 Replies
satishkurra
Specialist II
Specialist II

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

With the above expression it will exceed the 2008

For inclusion use + in place of - in above expression

Thanks

Satish

Not applicable

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!

Not applicable

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

Not applicable

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

Not applicable

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

Not applicable

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.

Not applicable

No I have only two Fields,one

Not applicable

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

Not applicable

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

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