Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-03-08 11:59 AM

Pivot table

i am facing a challenge in pivot tables as when i am trying to load the data from DB into pivot table with few filter conditions some of the rows are getting excluded so the corresponding dates are also getting excluded due to this there is date jump happening in date dimension but i want all the dates in date dimension, please help me in achieving this. below screenshot current status of the pivot table. thanks in advance.

764 Views
0 Likes
12 Replies
settu_periasamy
Master III
Master III
‎2016-03-09 08:30 AM

In response to

what do you mean by filtering condition? Can you share your expression?

114 Views
Not applicable
‎2016-03-09 11:31 AM
Author

In response to avinashelite

hi Avinash,

It actually worked thanks for your valuable time in this course.

and also I have unchecked suppress Null values in Dimension tab and I got the output that I desired.

114 Views
0 Likes
avinashelite
MVP
MVP
‎2016-03-09 12:32 PM

In response to

cool good to hear that i was able to help you

if you have got the answer please mark the correct and helpful answers , so that it will be helpful for others who are having the similar question

114 Views