Discussion Board for collaboration related to QlikView App Development.
Hi team, I have one table:
ID, Name, Sales
1, Hari, 2000
3, Naresh, 5500
4, Naresh, 3000
I want output like these
What is the script for that?
You can just create a table to show this using Name as dimension and Sum(Sales) as measure.
Qlik is case sensitive, so hari does not match Hari
If hari replace with Hari. Can you Please write the Script.
Max Value for Each name in a table.
LOAD ID, Replace(Name,'hari','Hari') as Name, Sales Inline [
LOAD Name, Max(Sales) as Sales Resident Sample Group By Name;
When there are some more wrong written names:
Table: LOAD UPPER(LEFT(Name,1))&LOWER(Mid(Name,2)) AS Name, MAX(Sales) AS Sales RESIDENT RawTable GROUP BY UPPER(LEFT(Name,1))&LOWER(Mid(Name,2)) ;
If the names are not proper in the table and if you want the dimension to be "Name", better go for captialize(Name) and use measure as max(Sales)
Capitalize(Name) as Name,
Max(Sales) as Sales
Group by Capitalize(Name);