topic Re: Pivot table alterations in QlikView

Pivot table alterations

Mon, 20 Jul 2015 13:26:46 GMT

Hi All,

Please find the attached Qvw. There are 3 sheets in the file. Each having Pivot table. The data showing in the table is not relevant. I need to order it. Details are mentioned in each sheet. kindly help me with this.

Thanks in advance.

Regards,

Keerthi KS

Re: Pivot table alterations

Anonymous — Mon, 20 Jul 2015 13:59:56 GMT

Hello,

Seems like you need to solve your problems on script level by editing your data (levels etc) accordingly.

Serhan

Re: Pivot table alterations

Mon, 20 Jul 2015 14:19:05 GMT

Can u help me with the script. Can't we do it in the table by using

calculated dimensions??

Re: Pivot table alterations

Anonymous — Mon, 20 Jul 2015 14:32:24 GMT

Hello,

You can't handle everything on the fly. Even we assume you can, it will be terrible performance.

So you need to prepare or clean your data. Best way is to do it on the source. Not sure what your source is but if you can prepare levels on the source it is much better.

I mean, if they are on different levels, how can you show them on the same level? It does not make sense. If you are not preparing the data, you need to ask the relevant people to prepare it as is.

Serhan

Re: Pivot table alterations

jagan — Tue, 21 Jul 2015 04:15:53 GMT

Hi,

In the last sheet change all Level dimensions as horizontal and WBS_final_code as verticaly, so that it would be easier to understand since you have less number of columns, this format is more readable.

For remaining scenarios can you attach the expected output screenshots. I think this should be handled in script level.

Attach some sample data and your expected output screenshots.

Regards,

Jagan.

Re: Pivot table alterations

Mon, 27 Jul 2015 03:47:19 GMT

HI Jagan,

I have some data coming from other sources. These data is due to some mistake during the data entry. Right now i dont want to correct it at the data level because it is done by someone else.

The required output is shown in the Qvw.

Please find the attached Qvw

Regards,

Keerthi KS