Case-sensitivity

[#1]

HI

I am little new to Qlikview and I am trying to get a count on these to values as I have shown to you in the below example

Ex

            NAME      TOTAL CLOSED INC

            Johan 23

                JOHAN               12

I want to combine these two as one and get the count as shown below

                        Johan 35

Would appreciate the help immensely

[its_anandrjs]

You can try with this

Source:

LOAD Capitalize(NAME) as NAME,[TOTAL CLOSED INC];

LOAD * INLINE [

       NAME,    TOTAL CLOSED INC

       Johan,     23

       JOHAN,   12

];

LOAD

NAME as NewName, sum([TOTAL CLOSED INC]) as [TOTAL CLOSED INC New]

Resident Source

Group By NAME;

DROP Table Source;

========================

If you want to keep the old table also then use and do not drop old table

Source:

LOAD Capitalize(NAME) as NAME,[TOTAL CLOSED INC];

LOAD * INLINE [

       NAME,  TOTAL CLOSED INC

       Johan, 23

       JOHAN, 12];

New:

LOAD

NAME, sum([TOTAL CLOSED INC]) as [TOTAL CLOSED INC New]

Resident Source

Group By NAME;

[SunilChauhan]

In dimension

Take Upper(NAME  )  or lower(NAME  ) or Capitalize(NAME  )

and in expression

sum(TOTAL CLOSED INC)

it will run as you required

thanks

[Joaquin_Lazaro]

Hi Shalani:

Search on QlikView help for this functions:

Upper

Lower

Capitalize

... I think in script time (load instruction) is better for yor app performance that in expression chart.

I hope it helps you.

Joaquin

[its_anandrjs · Accepted solution]

On the front end you can do like below by adding the new fields on the table load for Capatalise,Lower,Upper

Source:

LOAD

Capitalize(NAME) as CapitaliseNAME,  //Add new Fields

      Upper(NAME) as UpperNAME, //Add new Fields

      Lower(NAME) as LowerNAME, //Add new Fields

[TOTAL CLOSED INC]

From Location;

And according to you use

Dimension and Metrics like

Dimension:- CapitaliseNAME or UpperNAME or LowerNAME (But at a time only one)

Expression:- Sum([TOTAL CLOSED INC])

[#6]

thanks every one it really help me alot much much appreciated. thank you sooo much