Set Analysis Should work based on Particular field

[muniyandi]

Hi Team,

I have some problem with my set analysis .

Ex: I have data with 50 dimension. Budget expression work based on particular 3 filed, (Quarter, Party, Item )

when user select the filtered in 3 filed combination. budget should work .

My Expression:

Sum({1<Year='$(=Max(Year))' >} Budget_Value)

Problem:

1. using this expression Sum({1<Year='$(=Max(Year))' >} Budget_Value) 

Filtration don't affected.

2. using this expression Sum({<Year='$(=Max(Year))' >} Budget_Value) 

Filtration affected. to filter the other then 3 field selection getting  zero .

How to make it correct result.

Thanks,

Muni.

[#2]

Hi,

Can you post the app. So that will look into the app and could get the exact requirement

[muniyandi]

Hi All,

Expression should work for Quarter,Party,Item field only, how to omit other 47 column selection ?

[muniyandi]

Hi

Anybody know the answer ?

[#5]

Create Alternate States and use the alternate states for three filters and the chart

look at the sample app

[tresesco]

Check:

Set analysis - ignores filters on all fields bu... | Qlik Community and

Ignore all selections except some specific fields using Set Analysis

[muniyandi]

Thanks Tresesco.

[#8]

Try something like below:

sum({$<[$(=Concat({1<$Field-={'Quarter','Party','Item'}>}distinct $Field,']=,[')&']='),Year='$(=Max(Year))'>} Budget_Value)

I just used the approach which tresesco shared in the link.

Thanks,

Singh

[#9]

Try

Sum({1<Year='$(=Max(Year))', Quarter = $::Quarter, Party = $::Party, Item = $::Item >} Budget_Value)