topic Ignore selections in QlikView

Ignore selections

Fri, 29 Nov 2013 16:13:06 GMT

Hi all

Have a field 'Division' and would like the below expression to ignore any selections made to the field 'Divison' but the value changes when anything else is selected.

Num(

If([Numerator Only Flag] =1 And Sum(Numerator),

If([Numerator Only Flag]=1 And Summarise=0, Only(Numerator),

If([Numerator Only Flag]=0 And Summarise=1,Sum(Numerator)/Sum(Denominator),Only(Numerator)/Only(Denominator)))),[Format Code])

Re: Ignore selections

Gysbert_Wassenaar — Fri, 29 Nov 2013 16:26:58 GMT

Something like this perhaps:

Num(

If([Numerator Only Flag] =1 And Sum({<Division=>}Numerator),

If([Numerator Only Flag]=1 And Summarise=0, Only({<Division=>}Numerator),

If([Numerator Only Flag]=0 And Summarise=1,Sum({<Division=>}Numerator)/Sum({<Division=>}Denominator),Only({<Division=>}Numerator)/Only({<Division=>}Denominator)))),[Format Code])

Re: Ignore selections

Anonymous — Fri, 29 Nov 2013 16:29:59 GMT

Try you use set Analisys

Num(

If([Numerator Only Flag] =1 And Sum({$<Division = >}Numerator),

If([Numerator Only Flag]=1 And Summarise=0, Only({$<Division = >}Numerator),

If([Numerator Only Flag]=0 And Summarise=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))),[Format Code])

Re: Re: Ignore selections

Fri, 29 Nov 2013 18:22:17 GMT

When I put the above code on the table acts weird.For some Indicators the format changes but the values remain the same and the values change to null which looks like the selection in the list box 'Division' is affecting the table . I checked the format and its correct.

Please see screenshots attached.

Re: Re: Ignore selections

Anonymous — Fri, 29 Nov 2013 18:33:03 GMT

you can attach file QVW or file data?

Re: Re: Ignore selections

Fri, 29 Nov 2013 18:35:45 GMT

Sorry mate. I cant do it coz of confodential data. Will probably anonamize it and send it.

I am struggling to find a solution to it. Never really came across something like this.

Re: Re: Ignore selections

Anonymous — Fri, 29 Nov 2013 18:38:56 GMT

Okay

try this

Num(

If([Numerator Only Flag] =1 And Sum({$<Division = >}Numerator),

If([Numerator Only Flag]=1 And Summarise=0, Only({$<Division = >}Numerator),

If([Numerator Only Flag]=0 And Summarise=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))), only({$<Division = >}[Format Code]))

Num(

If(only({$<Division = >}[Numerator Only Flag]) =1 And Sum({$<Division = >}Numerator),

If(only({$<Division = >}[Numerator Only Flag])=1 And only({$<Division = >}Summarise)=0, Only({$<Division = >}Numerator),

If(only({$<Division = >}[Numerator Only Flag])=0 And only({$<Division = >}Summarise)=1,Sum({$<Division = >}Numerator)/Sum({$<Division = >}Denominator),Only({$<Division = >}Numerator)/Only({$<Division = >}Denominator)))), only({$<Division = >}[Format Code]))

Re: Ignore selections

Mon, 02 Dec 2013 16:02:59 GMT

Hi all. Thanks for your suggestions. I got it sorted with this bit of code

Num(

If([Numerator Only Flag] =1 And Sum({<Division -= >}Numerator),

If([Numerator Only Flag]=1 And Summarise=0, Only({<Division -= >}Numerator),

If([Numerator Only Flag]=0 And Summarise=1,Sum({<Division -= >}Numerator)/Sum({<Division -= >}Denominator),Only({<Division -= >}Numerator)/Only({<Division -= >}Denominator)))), only({<Division -= >}[Format Code]))