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: 
paolo_mapelli
Creator II
Creator II

Newbie question: how to preserve dimension values when filtering

Good Morning,

sometimes I get stuck into a simple problem, without reach out a solution...

I have a table like this:

Customer     Month     Revenue

A                 Jan         100

A                 Feb         100

B                 Jan         100

C                 Jan         100

D                 Jan         100

D                 Feb         100


Of course if I select "Feb" as month I get:

Customer     Month     Revenue

A                 Feb         100

D                 Feb         100


But I'd like to have this:


Customer     Month     Revenue

A                 Feb         100

B                 <null>     <null>

C                 <null>     <null>

D                 Feb         100


In other words, I'd like to have customers always shown, even they haven't revenue for that month.


Any suggestion ?


Thanks in advance.


Paolo.


7 Replies
sunny_talwar

May be this:

Capture.PNG

Settings needed

1) Dimension tab

Capture.PNG

2) Presentation tab

Capture.PNG

Anonymous
Not applicable

Hi Paolo,

will Pivot Table chart like below work for you?

Capture.PNG

Below is the setting for the pivot table above.

Pivot Setting.PNG

paul_scotchford
Specialist
Specialist

Err, that's qlikview I think it's a QlikSense question

sunny_talwar

My bad, I tend to not look at that after I have already posted my response. Need to keep an eye on this to make sure I post responses which are helpful.

Anonymous
Not applicable

‌in your expression definition add set analysis to ignore the selection made. I.e

sum({<[Month]=>} sales)

this technique is useful to brush just to highlighted selected dims.

paul_scotchford
Specialist
Specialist

Hey Sunny, your posts are always helpful, I'm just having a bit of fun there have a great day.

swuehl
MVP
MVP

Maybe have a look into what Henric shows here:

QlikSense Dimension: show all values like QlikView?

With more than 1 dimension, this probably won't really work well (looking at your requested outcome).