Filtering a master dimension with set analysis?

[#1]

Hi everyone,

I am a newbie in Qlik Sense and I am currently struggling with a Set Analysis.

In my database, all the dates have the same format (ex: 2015-09-11), so I created a master dimension with Year(expression) so I only have the Year available.

But now, when I am using this master dimension (called here "Año fecha entrega") and I want to create a filter through a Set Analysis on my measure expression in order to have only available in my graph datas from years 2013 to 2015, I am completely unable to find my way out, it never works.

I attach a qlik file so you can see what I mean.

Does anyone can help me and explain how can I filter those years in my graph?

Thank you!

[#2]

Oups, I put the wrong file attached.

Here is the correct one!

[ogster1974]

You've found an annoying gap in Sense currently.  You cannot use Master items in set Analysis or general expressions at the moment.

My guess is they need to be able to treat them like variables but they can't yet.

[brunobertels]

Hi Alexia

You should add a dimension Year in your data model like this :

year(Fecha_entrega__c) as anos,

Then in your app you will be able to add a calculated dimension

Dim =

If(anos>2013,if(anos<2015),anos,null()))

then in expression :

count(Proyecto_Generico__c)

Hope this'll help

Bruno

[hic · Accepted solution]

You cannot use set analysis on calculated dimensions. You have to use either a real field in the data model, or a derived field (as described in Qlik Sense – Date &amp; Time).

But once you have done this, you can use your formula:

   Count({1<"Año fecha entrega"={2013,2014,2015}>} Proyecto_Generico__c)

HIC

[#6]

It works perfectly following your indications!

Thanks a lot!

[#7]

Thank you very much!