topic Re: set anaylysis in QlikView

set anaylysis

srinivasa1 — Wed, 09 Jan 2013 01:11:10 GMT

can any one guide me how i can add variable = num($(vCalc)*100,'#.#') in below set analysis need to replace val1 and val2 with variable..

=MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType)}, Val1={"<=7.1"}, val2{">=7.1"}>}id)

Thanks

Re: set anaylysis

Wed, 09 Jan 2013 01:52:01 GMT

can u post the value(expression) of vCalc ?

Re: set anaylysis

Wed, 09 Jan 2013 01:57:14 GMT

Hi,

try like this

MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType), Val1={>=${=<$(Var)}}>}id)

Re: set anaylysis

srinivasa1 — Wed, 09 Jan 2013 02:17:30 GMT

Hi thanks for quick response.

it will be 7.1 .

but i need add >=vCalc and >= vCal

Thanks

Re: set anaylysis

srinivasa1 — Wed, 09 Jan 2013 02:24:57 GMT

Thanks for reply its shows some script error.

Re: set anaylysis

Wed, 09 Jan 2013 02:54:04 GMT

MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType), Val1={>${=<$(Var)}}>}id)

still if it is not working post your app with sample data

Re: set anaylysis

srinivasa1 — Wed, 09 Jan 2013 04:06:32 GMT

Thanks for replay i have attached file.pls dont worry about data.just i need change font color based on val1 and val2..for Value

thanks in advance

Re: set anaylysis

srinivasa1 — Wed, 09 Jan 2013 04:41:11 GMT

Any guidence.

Re: set anaylysis

srinivasa1 — Wed, 09 Jan 2013 04:48:24 GMT

chanred2 did you got my attached file.

Re: set anaylysis

Wed, 09 Jan 2013 09:48:56 GMT

Hi,

I have got somewhat. check the attached file.. i didn't use setanalysis but i implement through if statement.. if you want to see the formula the

go to expressiontab--> expandexpression there you can find textcolour..

regards,

Chandra

Re: set anaylysis

Wed, 09 Jan 2013 10:16:46 GMT

variables are use like this

=MaxString({$<Id={'E01'},Key={'$(=$(vKey))'}, Type={$(vType)}, val1={"<=$(var2)"}, val2={">=$(var1)"}id)

val1={"<=$(var2)"}

val2={">=$(var1)"}