Discussion board where members can get started with Qlik Sense.
I would really appreciate some help with this. I couldn't think of anything better for the topic title..
This is my data:
What I need:
In case the output table is not self explanatory, I need to create a dimension with 3 possible outcomes:
1. The "Acreedor" has one single ID for one single CODE (No examples in this table)
2. The "Acreedor" has one single ID, but 2 or more CODES
3. The "Acreedor" has 2 or more IDs, but one single CODE.
Thank you in advance.Kind regards.
How are you getting the "SAME CODE, DIFFERENT ID" values ? What is the logic behind it? If you can explain that may be we can help you out.
Create a temp table?
- Acreedor, count distinct ID, count distinct CODE
Join on your base table (just on the Acreedor field).
You will have something like:
From there, add new column with your logic?
if(NewCountID > 1 and NewcountCode = 1, 'same code different ID',
Not entirely sure about your request, But this is what i understand from explanation. Perhaps this?
If(ID = Previous(ID), Peek('Output') & AutoNumberHash256(ID)) as Output