topic Re: Evaluate a string in QlikView

Evaluate a string

Wed, 19 Sep 2012 09:03:31 GMT

hi guys,

I'm in trouble with an expression on my designer.

I have to build an expression. This expression depends on what you select on a field Month.

I have to sum a num of fields called TKF001, TKF002 ... TKF012.

If you select Month 01 and 02 i have to build an expression like that:

(TKF001 + TKF002) / 2

So, I tried to use Evaluate() functions but it doesn't work on designer.

I tried to put my string on a variable and then use it:

$(Var1)

Where Var1 = 'TFK0' & GetFieldSelections(VG.Month,'+TKF0',12)

but unfortunately it doesn't work too.

Any suggestions to help me.

Thanks a lot

Giampiero

I write for you my expression:

if(GetSelectedCount(VG.Mese)=0

,//THEN

(TKF001 + TKF002 + TKF003+ TKF004+ TKF005+ TKF006+ TKF007+ TKF008+ TKF009+ TKF010+ TKF011+ TKF012)/12

,//ELSE

Evaluate('TFK0' & GetFieldSelections(VG.Month,'+TKF0',12)) / GetSelectedCount(VG.Month)

)//ENDIF

Re: Evaluate a string

CELAMBARASAN — Wed, 19 Sep 2012 10:39:55 GMT

Try something like this

use concat or GetFieldSelections

=$(=Concat(DISTINCT 'Sum(TKF0'&VG.Month,')+')&chr(41))

Re: Evaluate a string

Wed, 19 Sep 2012 10:59:39 GMT

Hi,

Thank you so much.

It works perfectly.

I found a different way to solve my problem that work as well as yours.

($(= ('TKF0' & GetFieldSelections(VG.Mese,'+ TKF0',12)))) / GetSelectedCount(VG.Month)

Again, THANK YOU SO MUCH.

Re: Evaluate a string

agigliotti — Wed, 19 Sep 2012 13:10:37 GMT

Hi,

I have the following tables:

tab_0:

LOAD * INLINE [

Prodotto, Formula, Campo1, Campo2, Campo3

Prod1, Campo2*3, 1, 10, 100

Prod2, Campo3-Campo2, 2, 20, 200

Prod3, Campo1+Campo2, 3, 30, 300

];

tab_1:

NoConcatenate

Load *, Evaluate(Formula) as Prezzo Resident tab_0;

drop table tab_0;

but I get the "Prezzo" field values equals to NULL !

I have to obtain a table as below:

Prodotto, Prezzo

Prod1 30

Prod2 180

Prod3 33

How can I achieve it ?

Please let me know.

Many thanks.

Best Regards

Re: Evaluate a string

swuehl — Wed, 19 Sep 2012 13:29:08 GMT

Andrea,

maybe this is helpful, it discusses some different approaches to handle your issue:

http://community.qlik.com/thread/38857

Regards,

Stefan

Re: Evaluate a string

bruno_m_santos — Tue, 16 Oct 2012 09:46:39 GMT

Hi,

I liked a lot your post.

Has for some time I was looking for a solution like that.

I have a similar requirement.

= ($ = Concat (DISTINCT 'Sum ($ (vSetMTD)' & Measure, ') +') & chr (41)) works well.

but not this:

= ($ = Concat (DISTINCT 'Rank (Sum ($ (vSetMTD)' & Measure, ') +') & chr (41) & chr (41)

You know what might be wrong.

Thank you for your help.

Bruno

Re: Evaluate a string

CELAMBARASAN — Tue, 16 Oct 2012 13:16:52 GMT

Hi,

Check with this

=$(=Concat (DISTINCT 'Rank (Sum ($ (vSetMTD' & Measure,chr(41) & '+') & chr (41) & chr (41))

Re: Evaluate a string

bruno_m_santos — Tue, 16 Oct 2012 13:40:46 GMT

Hi,

Many thanks for your help.

Unfortunately the expression that you suggest doesn't return values.

I found another solution:

= $(=Concat(DISTINCT 'Rank('& 'Sum($(vSetMTD) '& Measure,')+')&')'& chr(44) &'0'& chr(44) &'1' &chr(41))

It's the right way to do it?

Thanks

Bruno