Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

First value in expression

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

9 Replies
Highlighted
MVP
MVP

Re: First value in expression

Can you provide some more information.

It is very difficult to understand from you question.

It's looks confusing...

Highlighted
Creator III
Creator III

Re: First value in expression

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

                                                                             3

Highlighted
MVP
MVP

Re: First value in expression

Don't understand at all.

Can you share sample file or apps?

Highlighted
Creator III
Creator III

Re: First value in expression

@Logic.PNG.png

Highlighted
MVP
MVP

Re: First value  in expression

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)

Highlighted
Creator III
Creator III

Re: First value in expression

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

Result should be named as 5 .

Only for this scenerio

Highlighted
MVP
MVP

Re: First value in expression

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))

Highlighted
Creator III
Creator III

Re: First value in expression

Hi Manish,

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

Highlighted
Creator III
Creator III

Re: First value in expression

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

I tried the expression below.

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)

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

Thanks in Advance,

Venkata