topic Re: Set Analysis Condition in QlikView

Set Analysis Condition

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

=sum({$<fiscal_period = {1} >}Credit_Begining + Debit_Beginning) *CBS_Rpt_Factor

I don't want above set analysis to change if user select period 2. What I want is to show only Period 1 numbers all the time.

so for example if user select 2, the numbers should not change. It would still show period 1 number

Please let me know how can I achieve it.

Re: Set Analysis Condition

Prashant_Naik — Sat, 29 Jun 2019 18:02:00 GMT

Hi,

Below expression might help

(sum({<fiscal_period = {1} >}Credit_Begining ) +sum({<fiscal_period = {1} >}Debit_Beginning) )*CBS_Rpt_Factor

I considered Credit_Begining + Debit_Beginning are 2 different fields

Regards,

Prashant

Re: Set Analysis Condition

has75042 — Sun, 30 Jun 2019 03:30:58 GMT

Hey Prashant,

Thanks for your reply. The number are still changing.

We just want to show last year period 1 numbers, regardless of what period users pick. Somehow is there a way to freeze it.

Re: Set Analysis Condition

haupenthals — Sun, 30 Jun 2019 12:23:29 GMT

Maybe CBS_Rpt_Factor is changing depending from the Fiscal Period?

Please try below:

(sum({<fiscal_period = {1} >}Credit_Begining ) +sum({<fiscal_period = {1} >}Debit_Beginning) )*sum({<fiscal_period = {1} Distinct CBS_Rpt_Factor)

Re: Set Analysis Condition

Gysbert_Wassenaar — Sun, 30 Jun 2019 14:15:38 GMT

Perhaps like this:

=sum({$<fiscal_period = {1} >}Credit_Begining + Debit_Beginning) *Max({$<fiscal_period = {1} >}CBS_Rpt_Factor)

Re: Set Analysis Condition

has75042 — Mon, 01 Jul 2019 03:18:42 GMT

=sum({$<fiscal_period = {1} >}Credit_Begining + Debit_Beginning) *Max({$<fiscal_period = {1} >}CBS_Rpt_Factor)

Thank you so much. The above set analysis is working.

Can you please explain me the reason behind max function?

Re: Set Analysis Condition

Gysbert_Wassenaar — Mon, 01 Jul 2019 07:16:41 GMT

Max will pick the mack CBS_Rpt_Factor value in case there is more than one value. I have no idea if that's the correct value.

If there is always only one value then Only() should work too. But if max works and only doesn't then there are several CSB_Rpt_Factor values and you need to decide which one to use. Perhaps that's the maximum value, but may you should use the minimum value or the average the values.