Put two column values in two different rows in same expression

razvan_brais — Thu, 06 Apr 2017 07:17:54 GMT

Hey guys. I have a problem.

In my table I have this kind of data

ID	Val1	Val2	Text1	Text2
1	123	234	one	two
2	0	0	-	-

What I want to do is that in my pivot table in expression tab I want to check

if(text1=one),123

and

if(text2=two,234)

And the info shown in my table to be something like this

ID	VALUE
1	123
1	234

how can I achieve this?

Thank you.

topic Put two column values in two different rows in same expression in QlikView