Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
Creator II
Creator II

Pivot Table

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

1 Solution

Accepted Solutions
srishsum2017
Creator
Creator

Hi plz check this

Sumit Kumar Srivastava

View solution in original post

11 Replies
srishsum2017
Creator
Creator

Hi

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

Sumit Kumar Srivastava
maniram23
Creator II
Creator II
Author

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,

farru_scorpio
Contributor III
Contributor III

Hi Mani,

Please check suppress zero value.

Capture.PNG

maniram23
Creator II
Creator II
Author

Hi Zubair,

We done same what you are suggested.

But I am getting null value in a dimension.

Regards

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
maniram23
Creator II
Creator II
Author

Hi Anil Babu,

It's not working. what you are suggested.

Regards

Anil_Babu_Samineni

Show me where you done?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
maniram23
Creator II
Creator II
Author

Hi Anil,

Please help Me.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)