Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore selections

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])

7 Replies
Gysbert_Wassenaar

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])


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

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])

Not applicable
Author

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.

Anonymous
Not applicable
Author

you can attach file QVW or file data?

Not applicable
Author

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.

Anonymous
Not applicable
Author

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]))

or

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]))

Not applicable
Author

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]))