Multiple column values into single column with distinct values by ID Level

venkyraj — Fri, 02 Jul 2021 10:26:29 GMT

Here the ID(1) is having Type_1 as A and Type_2 as B and Sales is 100(we need to sum up as 100 for each presentation) but will have one more new row for B for Type_2 then Sales will be 100*2 instead of 100,No of ID will be 3 instead of 1.

Data Set

topic Multiple column values into single column with distinct values by ID Level in QlikView

Multiple column values into single column with distinct values by ID Level