Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted
Creator
Creator

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

View solution in original post

9 Replies
Highlighted
Specialist
Specialist

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.

Highlighted
Creator III
Creator III

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

try with 'aggr' function

Highlighted
Creator
Creator

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.

Highlighted
Contributor
Contributor

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

Can you provide an example please?

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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

View solution in original post

Highlighted
Creator
Creator

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

Here my simple app

Highlighted
Contributor
Contributor

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

Thank you !!

This is it

Highlighted
Creator
Creator

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

You're welcome!