Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

paolo_mapelli
Contributor

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

Re: Newbie question: how to preserve dimension values when filtering

May be this:

Capture.PNG

Settings needed

1) Dimension tab

Capture.PNG

2) Presentation tab

Capture.PNG

mhartono
Contributor

Re: Newbie question: how to preserve dimension values when filtering

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
Valued Contributor

Re: Newbie question: how to preserve dimension values when filtering

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

Re: Newbie question: how to preserve dimension values when filtering

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.

Employee
Employee

Re: Newbie question: how to preserve dimension values when filtering

‌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
Valued Contributor

Re: Newbie question: how to preserve dimension values when filtering

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

MVP
MVP

Re: Newbie question: how to preserve dimension values when filtering

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).

Community Browser