Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Hi plz check this

Sumit Kumar Srivastava

View solution in original post

11 Replies
Highlighted
Creator
Creator

Hi

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

Sumit Kumar Srivastava
Highlighted
Creator II
Creator II

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,

Highlighted
Contributor III
Contributor III

Hi Mani,

Please check suppress zero value.

Capture.PNG

Highlighted
Creator II
Creator II

Hi Zubair,

We done same what you are suggested.

But I am getting null value in a dimension.

Regards

Highlighted

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

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)
Highlighted
Creator II
Creator II

Hi Anil Babu,

It's not working. what you are suggested.

Regards

Highlighted

Show me where you done?

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)
Highlighted
Creator II
Creator II

Hi Anil,

Please help Me.

Highlighted

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

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)