topic Pivot Table, wrong dimension grouping in QlikView

Pivot Table, wrong dimension grouping

Tue, 31 Jan 2017 10:48:10 GMT

Hi there,

I've been using for a while the Pivot Table and in the last project that I've been involved we've noticed a weird behavior on that element. For some reason when I expand a value of the dimension (in that case Country), the dimension spread into two groups the TOTAL row and the actual values.

As you can see in the picture seems that the first row of AF is showing the Total value, but I don't know why that row it's not linked to the real data.

Do you have any idea what might cause this behavior?

Thank you in advance.

Best Regards,

Carlos

Re: Pivot Table, wrong dimension grouping

Tue, 31 Jan 2017 11:59:49 GMT

Can you pls share some sample data....

Re: Pivot Table, wrong dimension grouping

rahulpawarb — Tue, 31 Jan 2017 12:13:35 GMT

Hello Carlos,

Sorry, your requirement is ambiguous. Please elaborate further by providing sample data and expected result.

Regards!

Rahul

Re: Pivot Table, wrong dimension grouping

Tue, 31 Jan 2017 12:21:52 GMT

Hi there,

Sorry if it wasn't clear the question.

That table it's made using a dimensions on a LinkTable.

However, I've been searching more deeply in the matter and I've just found the issue.

It's was due to the null values on the link table, I've replaced the null values by script (make it selectable ---- if(isNull(field1), '-', field1) as field1))

Now seems to be working.

Sorry again for the ambiguous question.

Thank you,

Carlos.