10 Replies Latest reply: Aug 30, 2018 2:38 AM by Krishna Chaitanya P

# 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

• ###### Re: QlikSense Dimension: show all values like QlikView?

You can trick Qlik Sense to show all values by using a different Measure. For instance, if you want to show

Sum( Sales )

then you can use the following expression instead:

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

The Set Analysis in the second term will force Qlik Sense to show all values, but since you multiply it by zero, the value will still be the correct one.

HIC

• ###### Re: QlikSense Dimension: show all values like QlikView?

Hello Henric,

thanks for your help. It works fine.

Regards, Henry

• ###### Re: QlikSense Dimension: show all values like QlikView?

Hi Henric,

Mine is the same requirement,

It's working when I use Sum( Sales ) + 0 * Sum( {1} Sales )

But when Use this in combo chart to show the linear trend line, it's showing as gaps as In screen shot.

• ###### Re: QlikSense Dimension: show all values like QlikView?

hic Hi Henric, but this trick is not working for me in Qlikview 12(SR4). Please see my problem below.

I have two fields, say

Table1: Field1,Name with values A,B,C,D

Table2: Field1,Date,Amount (Transactional Data Table but having values only for A,B,and C and it will never have values for D)

I am now making a Straight Table Chart with Dimension Field1 and Expression as if(Field1<>'D',Sum(Amount),some sum formula for D's value). But the problem is it's not showing value for D because there is no value for D in Table2. "Show All Values" is also not working.

Note:Formula above is written in narrative form for simplicity.

Thanks and BR,

SAK

• ###### Re: QlikSense Dimension: show all values like QlikView?

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.

• ###### Re: QlikSense Dimension: show all values like QlikView?

Hi Henrick,

I have a dimension called countries.

A filter date and some time slots :YTD MTD and so on  .
if I select date =31/12/2016 and MTD;

in my filter Countries, I will only have available one country (since the others have not done anything in the selected date)

This does not affect my graphics (since in the expressions,the KPI is independant of the date selection) but only affects my list selection (countries)

What can I do to force a list selection made of one dimension 'countries' to show all of my countries independant of the selection of a date:

with a set expression, I can simply do : {<date=>}, but since countries is a string, I can't use any aggregation; thus I couldn't find a solution !

Hope the issue is rather clear;

Thanks !

• ###### Re: QlikSense Dimension: show all values like QlikView?

I suggest you open a separate thread for this question, and post a document that shows your question.

HIC

• ###### Re: QlikSense Dimension: show all values like QlikView?

Henric,

Thank you.  I noticed this behavior and was in the process of determining the proper course of action when selecting dimensions in any of the data tables associated with the Master Calendar.

Your solution is both simple and logical.  I've been able to modify the measures in any chart visualization to allow the master calendar dates to display regardless of the selection that has been made.

Frank.

• ###### Re: QlikSense Dimension: show all values like QlikView?

I would probably try something like

Count(SERVICE_REQUEST) +

0*Count({1<MonthYear={"\$(=Date(Max(MonthYear),'MMM-YYYY'))"}>}SERVICE_REQUEST)

Then it would return all dates in the last month, irrespective of selection.

HIC

• ###### Re: QlikSense Dimension: show all values like QlikView?

Henric,

Thank you.  That worked perfectly once I adjusted the expression for the trend line to return only the selected values.

That was so because the expression that Mike Tarallo had posted in How to add lineal trend in Qlik sense:

linest_m(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)*

only({1}OrderDate)+linest_b(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)

returned all dates in the order clause.  Once I changed that to only({\$}OrderDate) the combo chart worked properly.

Frank.