Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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 🙂
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
Nice trick !
Hope simpler method in the future
Why simply writing :
Sum(Sales) + 0
is NOT Working ?