Text box function

[#1]

Hello Experts,

I am working with text boxes in Qlikview and I needed help in two things.

a. How can I add a where clause to the expression in the text box? Below is my expression and I want this expression to work only on the rows where actuals_sa is not blank. Is there a way this can be done?

= num(

         avg

              (Aggr  ( Sum ( actuals_sa ) , calender_date) /Aggr ( Sum ( CPE) , calender_date ) )

       ,'#.##%'

      )

b. Is it possible to detach the text box from some selections while making it responsive to others? Like in my chart I have 4 filters and I want this text box to respond to the selection change of only one of them. Any idea if this can be accomplished?

[vishsaggi]

You have to go to Use Advance editor link when you reply and attach the sample using attach link. Like below

[#3]

Thanks. Here it is.

[vishsaggi]

I missed adding these curly brackets.

= num(

        avg

              (Aggr  ( Sum ({< actuals_sa -= {''} >} actuals_sa ) , calender_date) /Aggr ( Sum ( CPE) , calender_date ) )

      ,'#.##%'

      )

And can i know where you performing this Min function.

In the dashboard you have sent i can see the percentage value in the Textobject for various selections ?

Any specific selection to be done to replicate the issue please let me know ?

[susovan]

Hi anuashka,

You can by bypass those dimension which you want to do not effect in your expression

[#6]

How do I do that? And the text box is a part of a sheet where I have other charts too and the filters need to work for those charts. Can I bypass certain filter for one specific object?

[#7]

Still seems to have some syntax error.

I am trying to perform the min function in this expression only. So basically I was looking to generate text boxes for three parameters, Min, max and avg values