Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

srinivasa1
Contributor

Set Analysis

Hi 

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

4 Replies
srinivasa1
Contributor

Re: Set Analysis

Hi

Is any guidence?

Thanks

Re: Set Analysis

Hi

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?

srinivasa1
Contributor

Re: Set Analysis

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

giakoum
Honored Contributor II

Re: Set Analysis

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

Community Browser