Discussion Board for collaboration on QlikView Scripting.
I want to show column1 values and 2nd column in one row..
Id Column1 Column2
1 125 -
1 300 -
1 - 520
1 - 452
1 125 452
2 300 520
Please help me with this issue.
Go to Solution.
Thank You for all your support.
I solved it.
For reference PFA.
Where does the 2 in the second line come from?
Use a straight table with ID as the dimension, and Sum(Column1) / Sum(Column2)
or Concat(Column1, ',') / Concat(Column2, ',') as expressions.
I want it in different row...concat wont work... and my column1 and column 2 is in string...
How did the result get id = 2? The source only seem to have id = 1?
You can't do much else with the sample data you provided.
The id will be the same for both the columns, only the problem is...its not showing in one row..
It seems that in your model you have a table loaded like this:
1 125 -
2 300 -
2 - 452
You should load it differently.
For example, if your table's name is TABLE, then:
DROP TABLE TABLE;
Then you will have this table:
1 125 520
2 300 452
the numbers are repeated twice..after using ur query
I cannot see any data or object on your sample that fits the problem described in your original post.