ignore all selections apart from 1 field

[hopkinsc]

Hi All,

I am trying to get some set analysis syntax to ignore all selections on fields apart from 1 specific field.

Can anyone help please?

I know using the '1' set modifier will ignore all current selections, but how do i tell it to include selections made on a specific field?

Sum{1<>}Sales

[hopkinsc]

does anyone have any ideas on this please?

[israrkhan]

Hi,

Try Like Below:

for example you want to ignore selection in Month , Year, Quarter, but want to keep selection in Country.

write like this,

Sum({$<Month=, Year= , Quarter= >}Sale).

You saw, i did not mention country here in expression, so it mean, it will take selection in country field, but will not take selections made in , Month, Year and Quarters Fields,

put your dimension in set expression, which you dont want in selections. Like Month= , Mean Month = All..

Hope it help, if not ask please.....

[hopkinsc]

Hi, thanks. the only problem is my data model has 100's of fields. i need to ensure that they are ALL excluded.

[#5]

Hi,

Try

Sum({1<Sales= $$:Sales>} Price)

Rebeca

[#6]

This can help you understand a little better

Set Analysis Wizard for QlikView | qlikblog.at

[hopkinsc]

Hi Rebeca, thanks.

Which part of that would i list my fields in that i don't want to be excluded?

I dont want Year or Month to be excluded.

Thanks

[jpapador]

the '1' makes all fields ignored the Sales=$::Sales makes it so Sales will be recognized I believe

[dvasseur]

Something like this ?

Sum({1<[Your field]={$(=Concat('"' & [Your field] & "'", ', '))}>} ...)

[hopkinsc]

i thought that syntax was for alternate states?