Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to hide excluded (not associated) values from a list, I usually do it with aggr function like this:
Aggr(Column, Column)
But now I need to do it for a calculated dimension, my dimension is :
If(isnull(ColumnB)=0, ColumnA)
I tried
Aggr(If(isnull(ColumnB)=0, ColumnA) , If(isnull(ColumnB)=0, ColumnA) )
But It's not working, any recommendation?
Thanks
How about this?
Aggr(Only({<ColumnB = {'0'}>} ColumnA) , Only({<ColumnB = {'0'}>} ColumnA))
Thanks Anil,
Are you sure it's doing the same thing? I used isnull function to make sure I filtered out all the rows in which ColumnB is null. is equal to {'0'} doing the same?
Those are thinking only not real one.. May be this?
=Aggr(Only({($ -<ColumnB={'*'}>)>} ColumnA),Only({($ -<ColumnB={'*'}>)>} ColumnA))
Or
Create field in script and i am sure, this will return same..
If(isnull(ColumnB)=0, 'Y', 'N') as FieldName
And the use Expression like below
Aggr(Only({<FieldName = {'Y'}>} ColumnA) , Only({<FieldName = {'Y'}>} ColumnA))
As a calculated Dimiension you have to use this (Isnull() function returns -1 if there is null for true)
If( isnull(ColumnB) = -1, ColumnA)
Aggr(If(isnull(ColumnB) = -1, ColumnA) , If(isnull(ColumnB) = -1, ColumnA) )
I want to exclude null values. anyway, if you read my question you'll see that's not my question.
I tried both solutions, When I write the expression it's ok, but in dashboard it says invalid dimension and shows nothing
Great, Will you able to provide sample?
not sure how to do that, my app is about 1 GB. Don't know how to create a small sample in qlik sense
I GB is really vast, Don't know how can we offer you.
1) Create 10 rows inline and then use same formula and share with us to look
2) Create few null rows and normal rows the state same