topic Re: Pivot Table Expansion in QlikView

Pivot Table Expansion

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

I am using a pivot table and in that am using dimesions that are from inline load

if i collapse the dimesion the chart isnt showing any values

any ideas to solve this problem?

Re: Pivot Table Expansion

bindu_apte — Thu, 09 Jun 2016 07:06:13 GMT

Hi,

Can you share sample qvw or the screenshot.

Re: Pivot Table Expansion

PrashantSangle — Thu, 09 Jun 2016 07:07:44 GMT

Hi,

are you using naked expression???

try your expression with sum()

like sum(YourExpression)

Regards

Re: Pivot Table Expansion

gautik92 — Thu, 09 Jun 2016 07:11:00 GMT

first table without collapsing

second table after collapsing

Re: Pivot Table Expansion

jonathandienst — Thu, 09 Jun 2016 07:15:49 GMT

Collapsing the dimension causes QV to use a total value (assuming you allowed partial totals). If you have the total as a line from you dimension, then this will be collapsed with the dimension.

If you need to be able to collapse a complex dimension, you will need a dimension one level above to collapse into.You can else create this in an inline. The Pick expression might need to take both dimensions into account.

Re: Pivot Table Expansion

jonathandienst — Thu, 09 Jun 2016 07:16:49 GMT

>>second table after collapsing -- It looks like you have not enabled partial totals.

Re: Pivot Table Expansion

gautik92 — Thu, 09 Jun 2016 07:27:14 GMT

I have enabled partial sums still it is not showing partial sum

Re: Pivot Table Expansion

pho3nix90 — Thu, 09 Jun 2016 08:48:11 GMT

Please upload your qvw, or at least your expression.

This sounds like an expression error. Or you are using a calculated dim?

Re: Pivot Table Expansion

jonathandienst — Thu, 09 Jun 2016 09:06:07 GMT

Lets see the definition of the inline dimension and the table expressions -- or better still, your qvw document or a representative sample (if its too large or you share the real numbers).

Preparing examples for Upload - Reduction and Data Scrambling

Re: Pivot Table Expansion

gautik92 — Thu, 09 Jun 2016 09:12:33 GMT

Hi jontydkpi

Now collapse is working i tried with pick function but still am not getting partial sums

it is showing null