topic Re: Set Analysis Should work based on Particular filed in QlikView

Set Analysis Should work based on Particular field

muniyandi — Mon, 27 Oct 2014 07:37:00 GMT

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.

Re: Set Analysis Should work based on Particular filed

Mon, 27 Oct 2014 07:42:21 GMT

Hi,

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

Re: Set Analysis Should work based on Particular filed

muniyandi — Mon, 27 Oct 2014 07:42:25 GMT

Hi All,

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

Re: Set Analysis Should work based on Particular filed

muniyandi — Mon, 27 Oct 2014 07:50:44 GMT

Anybody know the answer ?

Re: Re: Set Analysis Should work based on Particular filed

Mon, 27 Oct 2014 07:50:51 GMT

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

look at the sample app

Re: Set Analysis Should work based on Particular filed

tresB — Mon, 27 Oct 2014 07:52:39 GMT

Check:

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

Ignore all selections except some specific fields using Set Analysis

Re: Set Analysis Should work based on Particular field

muniyandi — Mon, 27 Oct 2014 08:00:54 GMT

Thanks Tresesco.

Re: Set Analysis Should work based on Particular field

Mon, 27 Oct 2014 08:13:58 GMT

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

Re: Set Analysis Should work based on Particular field

Mon, 27 Oct 2014 08:34:28 GMT

Try

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