topic Re: Pivot Table in QlikView

Pivot Table

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

HI Experts,

i have a pivot table. There i have three dimensions and one expression.

i need to show every day output (Include Missing Days). for that i was connected to master calendar.

After Connect to my master calendar i am receiving null values in a dimension calumn.

But I don't want to show the null values in a pivot table as a dimension level.

Please check for the reference i attached a file.

Regards

Re: Pivot Table

srishsum2017 — Tue, 22 Aug 2017 06:26:56 GMT

Please Check the attached qvw, i make some changs in dimension

Re: Pivot Table

maniram23 — Tue, 22 Aug 2017 06:49:31 GMT

HI Sumit,

Thank you. for your replay.

You done good. But i need to show all days data. But your Output Second day data is missed.

Regards,

Re: Pivot Table

farru_scorpio — Tue, 22 Aug 2017 07:03:08 GMT

Hi Mani,

Please check suppress zero value.

Re: Pivot Table

maniram23 — Tue, 22 Aug 2017 07:20:30 GMT

Hi Zubair,

We done same what you are suggested.

But I am getting null value in a dimension.

Regards

Re: Pivot Table

Anil_Babu_Samineni — Tue, 22 Aug 2017 07:29:06 GMT

Create day in script and use third dimension as Day. It deserve !!

Re: Pivot Table

maniram23 — Tue, 22 Aug 2017 07:37:21 GMT

Hi Anil Babu,

It's not working. what you are suggested.

Regards

Re: Pivot Table

Anil_Babu_Samineni — Tue, 22 Aug 2017 07:46:51 GMT

Show me where you done?

Re: Pivot Table

maniram23 — Tue, 22 Aug 2017 07:55:30 GMT

Hi Anil,

Please help Me.

Re: Pivot Table

Anil_Babu_Samineni — Tue, 22 Aug 2017 08:02:19 GMT

I can't reload because your data source is excel.

Re: Pivot Table

srishsum2017 — Tue, 22 Aug 2017 08:43:41 GMT

Hi plz check this

Re: Pivot Table

srishsum2017 — Tue, 22 Aug 2017 08:45:54 GMT

Actually 0 is not in dimension and it is subtotal....when i move it top or bottom subtotal it moves...so there is an only a alternative i know...if it is helpful for you so mark helpful other wise sorry