Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
what's the name of the function that returns the first element in a filed? for example, in the data i have:
sku # | sku name |
1 | a |
1 | a |
2 | b |
2 | b |
and in the straight table i want to get:
sku # (dimension) | sku name (expression) |
1 | a |
2 | b |
i know that i can achieve this by simply add "sku name" as a second dimension, but i want "sku name" to be a calculated expression.
any ideas?
thanks
Try just skuName as expression or maybe only(skuName).
Do your sku #'s have multiple sku names? or are they all a for 1, b for 2, etc?
Other function that may help is firstsortedvalue() if those dont work.
Hope this helps!
they are all a for 1, b for 2, etc... i tried your 3 alternative but it doesn't seems to work...
thanks
Maybe try maxString(skuName).
Else, could you post a sample qvw that demonstrates your problem?
thanks you jerem.
Using just Sku Name works for me in this example.