topic Re: Display first row when duplicate records exists in straight table. in QlikView

Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I have a table where records are stored in both upper case and lower case like below.I want to display only one row(firstsortedvalue) for Name="Bar chart" instead of 3 lines without converting it to any other format like upper,lower, capitalize.I am using the Name column in dimension.

LOAD * INLINE [

Name, Value

BAR Chart, 1

Bar Chart, 2

BAR CHART, 1

BB, 2

];

Re: Display first row when duplicate records exists in straight table.

MK_QSL — Thu, 12 Apr 2018 10:13:47 GMT

Use

UPPER(Name) as Dimension

and

SUM(Value) as an expression

Re: Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Thu, 12 Apr 2018 10:19:09 GMT

Thanks for the quick response. But i don't want to convert it to any other format like Upper, lower, capitalize. I just want to display the first value as it is.

Re: Display first row when duplicate records exists in straight table.

Anonymous — Thu, 12 Apr 2018 10:22:42 GMT

Is there any specific reason that you do not want to use upper/lower etc.? What you want to accomplish can easily be done using Manish's reply above.

Re: Display first row when duplicate records exists in straight table.

MK_QSL — Thu, 12 Apr 2018 10:22:48 GMT

How you decide which one is your first value?

Re: Display first row when duplicate records exists in straight table.

HarishG — Thu, 12 Apr 2018 10:26:09 GMT

you can use as Manish Kachhia suggested....or you can try this as well..

=if(WildMatch(Name,'*Bar*'),'BAR Chart',Name)

Re: Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Thu, 12 Apr 2018 10:29:03 GMT

I am just sorting it according to first loaded value.

Re: Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Thu, 12 Apr 2018 10:30:04 GMT

My requirement is to display only one value without changing it to upper or lower. In actual data user don't want to change it's format.

Re: Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Thu, 12 Apr 2018 10:31:38 GMT

This solution would be helpful when we have less number of records. But , i have multiple number of records in my actual table.

Re: Display first row when duplicate records exists in straight table.

HarishG — Thu, 12 Apr 2018 10:33:35 GMT

Multiple number of records as in? can you show or send us the formats or records?

Re: Display first row when duplicate records exists in straight table.

pooja_prabhu_n — Thu, 12 Apr 2018 10:41:00 GMT

like below.

LOAD * INLINE [

Name, Value

BAR Chart, 1

Bar Chart, 2

BAR CHART, 1

BB, 2

PIE CHArt, 1

Pie chart, 2

Pivot Table, 3

pivot TABLE, 1

];