Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pooja_prabhu_n
Creator III
Creator III

Display first row when duplicate records exists in straight table.

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

];

Input.PNG

Output.PNG

10 Replies
MK_QSL
MVP
MVP

Use

UPPER(Name) as Dimension

and

SUM(Value) as an expression

pooja_prabhu_n
Creator III
Creator III
Author

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.

benazirkhan
Creator II
Creator II

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.

MK_QSL
MVP
MVP

How you decide which one is your first value?

HarishG
Partner
Partner

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

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

Untitled.png

pooja_prabhu_n
Creator III
Creator III
Author

I am just sorting it according to first loaded value.

pooja_prabhu_n
Creator III
Creator III
Author

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.

pooja_prabhu_n
Creator III
Creator III
Author

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

HarishG
Partner
Partner

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