Discussion Board for collaboration on QlikView Scripting.
I have a table with the following structure:
Based on table1 I want to get the following table:
if(Name = 'A-name', Text) as A-name,
if(Name = 'B-name', Text) as B-name,
if(Name = 'C-name', Text) as C-name
But unfortunately my result is following table:
Can anyone help me?
Go to Solution.
Not Sure, How you Followed the Miguel`s suggestion. I followed his suggetsion, i could get the proper result.
Check out the attached application.
If your model is not very big, you can try a generic load in the script, that will leave the data as you expect
Table:GENERIC LOAD Number, Name, TextFROMC:\qcomGenericLoad.xlsx(ooxml, embedded labels, table is Sheet1);
GENERIC LOAD Number,
(ooxml, embedded labels, table is Sheet1);
You can get that in the chart, creating a new pivot table, using Number and Name as dimensions and Text or Only(Text) as expression.
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
thanks for your answer.
I tried the generic load and it simplifies my script, but the result is still the same (like table2 in my example).
Sleepa, oops..!! My thread may be helpful Answer and Miguel Angel Baeyens post should be correct one.
Please dont mind to change the correct and helpful answer status