Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
berndjaegle
Contributor

Set Analysis - Ignore all fields from one table

Hi guys,

looking for a smart solution to ignore selections from one table of my data model.

The data model is with a link table and I want to ignore one table for one KPI.

I know this option: 

sum({$<[Date]=,[City]=,[Client]=,[Amount]=>} Amount)

I don't want to mention all fields explicit. 

 

Something like

sum({$<[Table.$Fields]=>} Amount)

Any suggestions?

Thank you.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set Analysis - Ignore all fields from one table

It is possible with something like:

sum({< $(=concat({1< $Table = {'Calendar'}>} $Field, ' ,')) >} Amount)

- Marcus

View solution in original post

5 Replies
Somasundaram
Contributor III

Re: Set Analysis - Ignore all fields from one table

Hi,

we are not able to omit the data from particular Data table . There is no option in Set analysis. 

 

 


-Somasundaram
berndjaegle
Contributor

Re: Set Analysis - Ignore all fields from one table

Thanks for you reply.... also I am not satisfied about it 😐
MVP & Luminary
MVP & Luminary

Re: Set Analysis - Ignore all fields from one table

It is possible with something like:

sum({< $(=concat({1< $Table = {'Calendar'}>} $Field, ' ,')) >} Amount)

- Marcus

View solution in original post

Re: Set Analysis - Ignore all fields from one table

And in case you have spaces in your field names, then add square brackets around $Field like this

Sum({<$(=Concat({1<$Table = {'Calendar'}>} '[' & $Field & ']', ' ,'))>} Amount)

 

berndjaegle
Contributor

Re: Set Analysis - Ignore all fields from one table

Thank you Marcus! Solved my problem!