topic conditionally show expression values in QlikView

conditionally show expression values

Anonymous — Thu, 24 Jul 2014 15:44:58 GMT

I have expression resulting % values, I want to only show these values only>-500% and <500% , for all other values roll out values. I think,I should make it with condition expression but how should I make it for %?

Re: conditionally show expression values

Thu, 24 Jul 2014 15:56:30 GMT

Can you attach your sample file. Depending on the results you either *100 or /100.

Say your result is 45.6 then to convert to percent you *100 = 4560%

Then a simple if() will do.

Re: conditionally show expression values

Thu, 24 Jul 2014 16:01:57 GMT

Hi,

Well you can use an IF, something like this:

if($(vMyExpression) >-5 and $(vMyExpression) < 5,

$(vMyExpression)

) // Use it in your expression

-5 = -500%

5= 500%

vMyExpression = your % formula

Best Regards.

Re: conditionally show expression values

Anonymous — Thu, 24 Jul 2014 16:34:15 GMT

I made % values to show in chart Number tab, so it is automatically value *100.

In expression condition,

still I cant find desired results. where Act.@op is previous expression used here. Just to check values I have given 0,as I have now all values< 150%>2%

Re: conditionally show expression values

Thu, 24 Jul 2014 16:51:17 GMT

Possible to attach a sample file?

Re: conditionally show expression values

Anonymous — Thu, 24 Jul 2014 17:02:25 GMT

I found above will not be executed with the expression label in if statement. But it is either rolling out expression totally or showing all results. I want to display expression, however not following condition should be rolled out values.

Re: conditionally show expression values

Anonymous — Thu, 24 Jul 2014 17:30:33 GMT

here is the sample file...

Re: conditionally show expression values

Anonymous — Thu, 24 Jul 2014 17:44:47 GMT

try this for vs.OP%

=if([vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD)<5 and [vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD)>-5, [vs. OP YTD]/$(linPNLActualBalance_CY_YTD_BUD), 0)

and replicate it for other fields after verifying the conditions and tweaking the expression as necessary.