Creating expression

[#1]

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

[hic]

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

[#3]

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

[Vegar]

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

[#5]

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

SP

[#6]

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

SP

[MayilVahanan]

HI

Try like this

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

Hope it helps