Discussion board where members can get started with QlikView.
I am trying to get the require column(Final Data) in the below table
I have two columns in my straight table called Data1 and Data2 so I need to concatenate and get the required column called Final Data and this should be done in design level only, not in script level.
Any suggestions or help is highly appreciated.
Data1 &' '& Data2 as FieldData
Whats the logic to calculate Final Data. The output you have shown looks like not following any pattern. May be I am missing something?
What's the logic behind this requirement. It's very confusing. First result is AP & second one is null why?
Why last result is data 2 not 1?
Here the Data2 column data 'AP' is important to display.
Yes you are right we need to write logic to display the data as shown in the table
'important to display' is not a logical thing. You have to work on you requirement part. There has to be a criteria for everything.
Your Table does not have Logic.
if you just want then togaher
will work otherwise you can use if on the top of it.