Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User
I have found a technqiue via another post where the functionality of an expression is controlled through a variable
However I would now like to add other functions to this technique, but am unsure on how to do so
Could someone kindly take a look at the attached document and kindly help me as to how I could get it to work with 95th Centile, using the fractile function
Kind Regards
Helen
May be using this expression:
=$(=v_expression&'('&'data'& If(v_expression = 'Fractile', ', 0.95') & ')')
May be using this expression:
=$(=v_expression&'('&'data'& If(v_expression = 'Fractile', ', 0.95') & ')')
Thanks Sunny
Perfect! This works for me
Thanks
Helen
Hello SunnyT
I was wondering if you could kindly help me amend the expression for this post from earlier today
I would like to add another button which counts the ID when a wait is over 4 hours
How would I incorporate the following expression so that a button can activate the equation
=Count(If(ED_Total_Wait>240,ED_ID))
I have tried the following, but it it erroring, perhaps I am asking too much of the technique
=$(=v_expression&'('& v_data &
If(v_expression = 'Fractile', ', 0.95')
&
If(v_expression = 'Count', ', If(ED_Total_Wait>240,ED_ID))'
')')
Are you able to help
Kind Regards
Helen
Not sure what ED_Total_wait and ED_ID correspond to in the sample above, but may be this:
=$(=If(v_expression = 'count', v_expression &'(If(ED_Total_Wait > 240, ED_ID))',
v_expression & '(' & 'data' & If(v_expression = 'Fractile', ', 0.95') & ')'))
Corresponding expression for your sample:
=$(=If(v_expression = 'count', v_expression &'(If(data > 240, dimension))',
v_expression & '(' & 'data' & If(v_expression = 'Fractile', ', 0.95') & ')'))