topic Re: How to stop this odd behaviour on pivot table in QlikView

How to stop this odd behaviour on pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am pulling a pivot table into the excel sheet.

Strangely it is showing these figures in excel sheet but not in Qlikview pivot table.How to stop these.Figure 1 is in qlikview.

Fiigure 2 is in Excel sheet.

Re: How to stop this odd behaviour on pivot table

vinieme12 — Wed, 01 Feb 2017 15:50:31 GMT

I think the cells are merged, wrap text to 3 or 4 lines to see if they are showing up in Service type column

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 15:53:50 GMT

Yes i tried but it is doing nothing.

Re: How to stop this odd behaviour on pivot table

Anil_Babu_Samineni — Wed, 01 Feb 2017 15:58:42 GMT

Can you share that Excel file and meantime Qlikview File if possible

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 16:12:02 GMT

why i am unable to attach any qlikivew or excel file?

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 16:13:51 GMT

This is the sample file and you can see top column near month/year that is displaying jan/1900

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 16:23:54 GMT

Hi ,

This is the sample file i have uploaded . where ever there is integer data type .

In this example service type has got 4 and next to that DATE column which is pivoted is giving the odd behaviour when i am sending this pivot to excel sheet.

You can notice that in this qvw.

Re: How to stop this odd behaviour on pivot table

vishsaggi — Wed, 01 Feb 2017 16:52:59 GMT

May be try this ?

LOAD date, [Group name], TEXT([Service Type]) AS ServiceType;

LOAD date,

[Group name],

[Service Type]

FROM

(biff, embedded labels, table is Sheet2$);

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 17:16:33 GMT

Yes that load script has done the trick when i was using my sample file.

But the same code is not working for QVW.

Re: How to stop this odd behaviour on pivot table

vishsaggi — Wed, 01 Feb 2017 17:23:32 GMT

Use same for your actual load script where you pulling your Service Type from. Is your service type a calculated field or is that coming from an excel source or any other source? Can you share your actual script by scrambling?

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 17:28:38 GMT

services:

LOAD id as service_id,

Text([name]) as service_name;

SQL SELECT *

FROM "myhealth_production"."public".services;

No it is coming from database.

Re: How to stop this odd behaviour on pivot table

vishsaggi — Wed, 01 Feb 2017 18:28:07 GMT

So, it still doesn't work ?

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 18:45:36 GMT

No.it is still showing those odd bits

Re: How to stop this odd behaviour on pivot table

vishsaggi — Wed, 01 Feb 2017 18:54:50 GMT

Can you scramble your data and share your actual app ?

Re: How to stop this odd behaviour on pivot table

Anonymous — Wed, 01 Feb 2017 20:37:54 GMT

I have left the office earlier.I shall share it across tomorrow.