Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filtering a master dimension with set analysis?

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!

1 Solution

Accepted Solutions
Employee
Employee

Re: Filtering a master dimension with set analysis?

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 & 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 Replies
Not applicable

Re: Filtering a master dimension with set analysis?

Oups, I put the wrong file attached.

Here is the correct one!

ogster1974
Honored Contributor II

Re: Filtering a master dimension with set analysis?

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
Valued Contributor

Re: Filtering a master dimension with set analysis?

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

Employee
Employee

Re: Filtering a master dimension with set analysis?

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

Not applicable

Re: Filtering a master dimension with set analysis?

It works perfectly following your indications!

Thanks a lot!

Not applicable

Re: Filtering a master dimension with set analysis?

Thank you very much!