topic QLIKSENSE STRINGS AND NUMBERS TREATMENT in App Development

QLIKSENSE STRINGS AND NUMBERS TREATMENT

Anonymous — Thu, 05 Apr 2018 20:54:30 GMT

Why does Qliksense treat this two text fields as the same 8828 and 00008828? I have used Text(Fieldname) in my LOAD statement and it still has not fixed it. This therefore affects my join and gives me wrong representation of data on my app,

Kindly help.

Re: QLIKSENSE STRINGS AND NUMBERS TREATMENT

Digvijay_Singh — Thu, 05 Apr 2018 21:52:32 GMT

Are the values loaded in 'Fieldname' thru other tables as numeric value before you have used text(Fieldname), may be its because the formatting is decided during initial load of this field.

You may do this simple test by adding this table in the beginning of the script -

Load text(Fieldname) as Fieldname inline [

Fieldname

00008828

Pl share sample data to try further in case you have other situations..

Re: QLIKSENSE STRINGS AND NUMBERS TREATMENT

Anonymous — Wed, 11 Apr 2018 19:58:33 GMT

Thanks Digvijay

The values are for a field called Profit Centres. I am loading the data from Employee Active File and then joining with Employee Terminations File.

ACTIVE FILE

PROFIT_CENTRE_CODE EMPIDs PROFIT_CENTRE_NAME ORGNAME COUNTRY

000001208 02 Susquehanna Procurement Services South Africa

1208 03 NULL Delivery Services Seychelles

TERMINATIONS FILE

PROFIT_CENTRE_CODE EMPIDs PROFIT_CENTRE_NAME ORGNAME COUNTRY

000001208 04 Susquehanna Procurement Services South Africa

1208 10 NULL Delivery Services Seychelles

Once I load the data on Qliksense and autojoins are created as required. Empids are counted.

On the app:

When I select Seychelles filter, I find 00001208 listed as one of the profit centres with no employee count at all?

But 1208 does not exist at all.

On selecting the South Africa data behaves ok I find right count in employees.

Re: QLIKSENSE STRINGS AND NUMBERS TREATMENT

Anonymous — Wed, 11 Apr 2018 20:49:18 GMT

IGNORE ABOVE..Use this:

Thanks Digvijay

The values are for a field called Profit Centres. I am loading the data from Employee Active File and then joining with Employee Terminations File.

ACTIVE FILE

PROFIT_CENTRE_CODE EMPIDs PROFIT_CENTRE_NAME ORGNAME COUNTRY

000001208 02 Susquehanna Procurement Services South Africa

1208 03 NULL Delivery Services Seychelles

TERMINATIONS FILE

PROFIT_CENTRE_CODE EMPIDs PROFIT_CENTRE_NAME ORGNAME COUNTRY

000001208 04 Susquehanna Procurement Services South Africa

1208 10 NULL Delivery Services Seychelles

Once I load the data on Qliksense and autojoins are created as required. Empids are counted.

On the app:

When I select Seychelles filter, I find 00001208 listed as one of the profit centres with counts of employees

But 1208 does not exist at all.

On selecting the South Africa data behaves ok I find right count in employees under 00001208.