Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobLag
Contributor
Contributor

Dynamic Dimension depending on Calculation

Dear All,

can you help me with a question regarding restricting a dimension by using dynamic dimension?

  • By using the formula "=if(FIELD='X' and FIELD='Z', FIELD, Null())" as dynamic dimension and activating the option "Omit NULL-Values", it is very easy to restrict the dimension to the values 'X' and 'Z' (FIELD={X,Y,Z}).

My problem is, how do I restrict the dimension when it depends on a calculation? For example,

  • By using a formula like "=if(count(ClientIDs)>0, FIELD, Null())".
  • For instance, value 'X' has 20 ClientIDs, value 'Y' has 0 IDs and value 'Z' has 10 IDs.
  • I need a formula, that restricts my dimension to value X and Z (in the example) cause of the number of ClientIDs >0.

Is this possible with dynamic dimension?

Thanks to all

Labels (2)
1 Solution

Accepted Solutions
awaisqureshi
Contributor III
Contributor III

Hi @JacobLag 

I think you can use the AGGR function in this case.

if(aggr(nodistinct count(ID),Field)>0,Field,Null())

View solution in original post

2 Replies
awaisqureshi
Contributor III
Contributor III

Hi @JacobLag 

I think you can use the AGGR function in this case.

if(aggr(nodistinct count(ID),Field)>0,Field,Null())

View solution in original post

JacobLag
Contributor
Contributor
Author

Hi @awaisqureshi ,

it works, perfect 🙂 Thank you very much!