topic Re: First value in expression in QlikView

First value in expression

venkatg6759 — Wed, 02 Apr 2014 18:18:08 GMT

Hi All,

I have an expression like ,,7 in which i need result in another expression like 7

IF expression has something like ,Top3,1, Result should be 3

All the values in the expression are separated by commas, I need first sorted value among those.

,,7 this value is coming from an expression which is combination of fields separated by comma.

Help me how to achieve this logic .

Thanks,

Venkata

Re: First value in expression

MK_QSL — Wed, 02 Apr 2014 18:24:52 GMT

Can you provide some more information.

It is very difficult to understand from you question.

It's looks confusing...

Re: First value in expression

venkatg6759 — Wed, 02 Apr 2014 18:27:12 GMT

I have an expression

if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()])

which is giving results such as ,,,7

Top 3,,2

I Need another expression in which result should be 7

Re: First value in expression

MK_QSL — Wed, 02 Apr 2014 18:51:15 GMT

Don't understand at all.

Can you share sample file or apps?

Re: First value in expression

venkatg6759 — Wed, 02 Apr 2014 19:07:28 GMT

Re: First value in expression

MK_QSL — Wed, 02 Apr 2014 19:12:29 GMT

Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1)

Re: First value in expression

venkatg6759 — Wed, 02 Apr 2014 19:30:02 GMT

Thank you Manish .This is helpful if suppose there is something like Tier2,,,

Result should be named as 5 .

Only for this scenerio

Re: First value in expression

MK_QSL — Wed, 02 Apr 2014 20:07:20 GMT

IF(Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'Tier2'),5)='Tier2',5,Left(KeepChar(if([Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]<>',,,',[Research - US Shares ()]&','&[Overall - US Shares ()]&','&[Research - All Products ()]&','&[Overall - All Products ()]),'0123456789'),1))

Re: First value in expression

venkatg6759 — Wed, 02 Apr 2014 20:08:33 GMT

Hi Manish,

If there is TOP10, it is displaying 1 instead of 10 .Any suggestion.

Re: First value in expression

venkatg6759 — Tue, 08 Apr 2014 13:36:14 GMT

Can Anyone help me how can i get the first number from the expression .

I tried the expression below.

But if i have numbers like TOP 10, it is displaying 1 instead of 10 .

Thanks in Advance,

Venkata