topic Re: Creating expression in QlikView

Creating expression

Thu, 01 Nov 2012 14:33:26 GMT

Hi All,

Please help me with the following issues

issue1:

I am trying to create an expression some thing like this

=if(a=b,'Exception','nonexception')

rather than returning Exception how can I mek the expression to return multiple variables

for example

if(a=b, (x1,x2,x3,x4),(y1,z2,z4))

issue 2:

I am getting $Syn variables, how can we avoid $syn

how can i make join between specific tables (through maby tables have same variables) rather than qlikview auto joins

Many thanks in advance

Re: Creating expression

hic — Thu, 01 Nov 2012 14:50:48 GMT

Issue 1:

If the result of the expression should be stored in a field (expression in the script) or displayed in e.g. a text box (expression in the layout), there can be no more than one value. If you want several values, then you probably want to store them in several fields:

if(a=b, x1, y1) as field1,

if(a=b, x2, y2) as field2,

Issue2:

$Syn keys are not necessarily bad. But if you want to get rid of them, then you need to have only one field linking two tables, e.g.

OldKey1 & '|' & OldKey2 as NewKey

This way you can create new keys and still have all links correct.

HIC

Re: Creating expression

Thu, 01 Nov 2012 14:52:54 GMT

if(a=b, 'x1,x2,x3,x4','y1,z2,z4')

for removing synthetic keys u can find good info on the community or for beginners purpose go thru the reference manual where u can find tips like renaming fields with same name across different tables.

joins can be made on common fields between two tables

Re: Creating expression

Vegar — Thu, 01 Nov 2012 15:01:00 GMT

Use the show-condition in the graph to accomplish what you want. See my attached example.

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se

Re: Creating expression

Thu, 01 Nov 2012 16:43:22 GMT

Hi Qlik_techie,

my X1,X2,X3.. and Y1,Z2 are valued variables

I am looking for returning the corresponding values in my pivot table rahther than the returning 'x1,x2,x3,x4'

Thanks

Re: Creating expression

Thu, 01 Nov 2012 16:43:45 GMT

Hi Qlik_techie,

my X1,X2,X3.. and Y1,Z2 are valued variables

I am looking for returning the corresponding values in my pivot table rahther than the returning 'x1,x2,x3,x4'

Thanks

Re: Creating expression

MayilVahanan — Thu, 01 Nov 2012 16:48:06 GMT

Try like this

if(a=b, x1&','&x2&','&x3&','&x4,y1&','&z2&','&z4)

Hope it helps