Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

davidrad1011
New Contributor

how to show fixed set of data in a dimension

Hi,

My question is simple realy but i havn't found an answer anyware.

I have a simple table with one colum (dimension) detalies the names of my employees, and the second colum (dimension) their status (active, MLOA etc.)

How can i make the table to show only the employees with a specif dimension, without it being impacted by filter and aggreagation options.

I tried set-analyis, but it wotks only with measure.....

Thank you

1 Solution

Accepted Solutions
paola_valenti
New Contributor III

Re: how to show fixed set of data in a dimension

I was thinking something like this:

Sample1.PNG

if you filter some value, nothing will happen in tables with set analysis.

Sample1_filter.PNG

9 Replies
arvind1494
Valued Contributor

Re: how to show fixed set of data in a dimension

It must be done with the help of set analysis .

Please share your data samples then we will able to resolve this.

ChennaiahNallani
Contributor III

Re: how to show fixed set of data in a dimension

try with 'aggr' function

paola_valenti
New Contributor III

Re: how to show fixed set of data in a dimension

hi,

if you use set analysis in measure expression and specify in the set the desired dimension value, you will obtain exactly what you need in your dimension in the table.

Filter will not impact on that dimension for that table.

davidrad1011
New Contributor

Re: how to show fixed set of data in a dimension

Can you provide an example please?

jothimala
New Contributor II

Re: how to show fixed set of data in a dimension

Hi !!

Try this out!!

if(DimensionField='value', Emp_Name_Field)

The value may be the value of particular dimension on which you want to filter

paola_valenti
New Contributor III

Re: how to show fixed set of data in a dimension

I was thinking something like this:

Sample1.PNG

if you filter some value, nothing will happen in tables with set analysis.

Sample1_filter.PNG

paola_valenti
New Contributor III

Re: how to show fixed set of data in a dimension

Here my simple app

davidrad1011
New Contributor

Re: how to show fixed set of data in a dimension

Thank you !!

This is it

paola_valenti
New Contributor III

Re: how to show fixed set of data in a dimension

You're welcome!

Community Browser