This content has been marked as final. Show 8 replies
I am new to Qlik and working on a POC. In our data we have unique ids for each record; however, some of those records have the same name. I do not want to use the name dimension because I will end up grouping records that do not go together. I would like to use the id dimension but display the name. I have included some sample data below.
|1||Bob Jones||Product A||1500|
|1||Bob Jones||Product B||2000|
|2||Bob Jones||Product A||1000|
|2||Bob Jones||Product B||1000|
|3||Mary Jones||Product A||1000|
Below is an example of what the final output would look like. This groups everything properly and Bob Jones is listed twice because he as two unique ids.
Is this possible in Qlik? I would appreciate any help.