topic Re: Set Analysis in QlikView

Set Analysis

srinivasa1 — Thu, 10 Jan 2013 03:19:27 GMT

I know I’m making mistake in SetAnalysis not able to figure out how to achieve this

I need to change font color of text object dynamically based on List box CalcValue selection ie: if selected 7 from calcValue list box its falls under (Low Value 1 and HighValue 10) in that case need to set textObject calculated font color as RGB(255,0,0) same way if calc value changes color code must change based on low and high val color.

below is script and i have attached dummy application

=MaxString({$<ID={'$(=$(v_ID))'},Key={'$(=$(v_Key))'}, type={$(v_Type)}, LowVal={"<=$(v_calcVal)"}, HighVal={">=$(v_calcVal)"}Color)

Highly appreciate help on this

Re: Set Analysis

srinivasa1 — Thu, 10 Jan 2013 13:40:56 GMT

Is any guidence?

Thanks

Re: Set Analysis

MayilVahanan — Thu, 10 Jan 2013 14:02:37 GMT

Try like this

=MaxString({$<ID={'$(=$(v_ID))'}, type={'$(=$(v_Type))'}, LowVal={"<=$(=$(v_calcVal))"}, HighVal={">=$(=$(v_calcVal))"}>}Color)

Have doubt, calcValue is not link with any field just using for calculation purpose, then why you can't use input box instead of list box?

v_key is always specific women only?

Re: Set Analysis

srinivasa1 — Thu, 10 Jan 2013 14:14:53 GMT

Thanks For your replay.

your right calcValue is not link with any field just using for calculation purpose.i need use like this only

v_key is always specific not women it also foe man based on add type form button

still my font color not get change i need use setanalysis as caluclated color

Thanks

Re: Set Analysis

giakoum — Thu, 10 Jan 2013 14:23:01 GMT

Please see attached.

Changes :

1. Variables needed = sign

2. Set analysis had wrong syntax

3. 3 new columns in excel for R, G, B

4. By using GetSelections you need to select something in those fields in order to get a result