topic Re: first element in a filed in QlikView

first element in a filed

Mon, 25 Nov 2013 19:56:01 GMT

hi,

what's the name of the function that returns the first element in a filed? for example, in the data i have:

and in the straight table i want to get:

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

jerem1234 — Mon, 25 Nov 2013 20:03:56 GMT

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!

Mon, 25 Nov 2013 20:08:00 GMT

they are all a for 1, b for 2, etc... i tried your 3 alternative but it doesn't seems to work...

thanks

jerem1234 — Mon, 25 Nov 2013 20:11:52 GMT

Maybe try maxString(skuName).

Else, could you post a sample qvw that demonstrates your problem?

Mon, 25 Nov 2013 20:37:43 GMT

thanks you jerem.

Josh_Good — Mon, 25 Nov 2013 22:06:05 GMT

Using just Sku Name works for me in this example.