Discussion board where members can get started with Qlik Sense.
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:
But I'd like to have this:
B <null> <null>
C <null> <null>
In other words, I'd like to have customers always shown, even they haven't revenue for that month.
Any suggestion ?
Thanks in advance.
May be this:
1) Dimension tab
2) Presentation tab
will Pivot Table chart like below work for you?
Below is the setting for the pivot table above.
Err, that's qlikview I think it's a QlikSense question
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.
in your expression definition add set analysis to ignore the selection made. I.e
this technique is useful to brush just to highlighted selected dims.
Hey Sunny, your posts are always helpful, I'm just having a bit of fun there have a great day.
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).