topic Re: Case-sensitivity in QlikView

Case-sensitivity

Tue, 13 May 2014 08:13:37 GMT

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

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

Re: Case-sensitivity

its_anandrjs — Tue, 13 May 2014 08:30:17 GMT

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;

Re: Case-sensitivity

SunilChauhan — Tue, 13 May 2014 08:33:30 GMT

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

Re: Case-sensitivity

Joaquin_Lazaro — Tue, 13 May 2014 08:34:14 GMT

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

Re: Case-sensitivity

its_anandrjs — Tue, 13 May 2014 08:39:24 GMT

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

Re: Case-sensitivity

Tue, 20 May 2014 03:36:33 GMT

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