Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
berndjaegle
Creator II
Creator II

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.

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

It is possible with something like:

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

- Marcus

View solution in original post

5 Replies
Somasundaram
Creator III
Creator III

Hi,

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

 

 


-Somasundaram
berndjaegle
Creator II
Creator II
Author

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

It is possible with something like:

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

- Marcus

View solution in original post

sunny_talwar

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
Creator II
Creator II
Author

Thank you Marcus! Solved my problem!