Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, everyone!
I'm trying to create a dimension with the expression: =IF(AGGR(SUM({1} Investment), Vehicle) > 0, Vehicle, Null()).
I want to show only the variables that have 'Investiment' for each 'Vehicle', for the whole dataset, greater than 0, but somehow It's now working.
I will add this dimension in a table after that, but only show the Vehicles that have more than 0 in Investiment for the whole dataset.
Can someone help me, please?
Try
=Aggr(If(Sum({1} Investment) > 0, Vehicle, Null()), Vehicle)
I think you need to provide a Dimension value in the Aggr.
=Aggr(If(Sum({1} Investment) > 0, Vehicle, Null()), Vehicle)
-Rob
Thanks for the support, Brun and Rob, but the script you guys recommended is working just as mine.
It isn't working properly, because one 'Vehicle' that has 'Investment' is becoming Null.
I still don't know what to do.
Is it sometimes spelled "Investiment" and sometimes "Investment"?
Because that would cause your problem
Sorry for my english kkkkkkk
I wrote it wrong here, but in Qlik it is just fine, the script is running, but not returning properly, unfortunately.