Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which have values like this
Product-1 | A01 |
Product-1 | A02 |
Product-1 | B01 |
Product-1 | C01 |
Product-1 | C02 |
Product-1 | C03 |
Product-2 | A01 |
Product-2 | B01 |
Product-2 | B02 |
Product-2 | C01 |
I want the final output like this
Product-1 C03
Product-2 C01
In A,B and C, C is the latest version and in C01 and C02, C02 is the latest.
Basically it's like picking the latest version.
How can we do something like this in Qlik?
You may apply an aggregation like maxstring(), for example:
t: load P, S from X; inner join(t) load P, maxstring(S) as S resident t group by P;