Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
hrolofs
Contributor III
Contributor III

QlikSense Dimension: show all values like QlikView?

Hello,

if there a possibility to do something like "Show all Values" in QlikView on the dimension definition for a diagramm?

In QlikSense i found only "Show null values".

My goal is to have a "fixed" dimension with all fiel dvalues, even if it selected or not. Like i can do it in QlikView.

Regards, Henry

13 Replies
Anonymous
Not applicable

Thanks Henric, you saved me.

I tweaked your idea into the following ... hopefully it will help people with similar problem

Sum({$<processed={True}>} sales) + 0*Sum({$} sales)

I have a datepicker in my sheet.

When i don't have any selections, i get to see all values.

And when there are selections, they are honored.

Jellowbean
Contributor
Contributor

MIne isnt working at all either. i've tried your expression above and it still shows my values on an axis and not as a line even though the line is selected?

 

I'm a very newbie beginner and not very clued up, trying to self study 🙂 

 

Saravana325LITC
Contributor
Contributor

Also 

then you can use the following expression instead to include your filter selection:

  Sum( Sales ) + 0 * Sum( {$} Sales )

it helps me a lot, Thanks Henric_Cronstrom

flagamba
Contributor III
Contributor III

Nice trick !

Hope simpler method in the future

Why simply writing : 
Sum(Sales) + 0 
is NOT Working ?