Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating expression

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

6 Replies
hic
Former Employee
Former Employee

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

Not applicable
Author

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
MVP
MVP

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

Not applicable
Author

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

Not applicable
Author

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.