and created 49 Formulas with each state variable output.
Problem now is: It only shows the first entry. I can replace the whole expression in the if condition with a specific number (100) and get a result. I also plotted the inner expression into a Listbox and checked wheter the result is not null.
As soon as I delete the aggr function and just take the AVG over everything (which is not what i want). Everything works fine. When i turn back to aggr, only the first one is shown.
Doesnt help by the way when i delete one of the dimensions, this doesnt work one dimensional either.
If you're talking about fields perhaps you should use the CrossTable function to transform your data into a format that easier to work with. Can you post an example file with data like your source data?
The problem here lies in the combination of AGGR() and two synthetic dimensions... When AGGR is used in Chart expressions, all Chart Dimensions need to be added to the dimensions of AGGR(), or else only one of the chart lines will get calculated, and others won't - and that, if I understand correctly, is the problem here.
However, Synthetic dimensions can't be added to AGGR, only static fields can be.
Bottom line, this problem requires a different solution, and for that a sample document would be useful.
Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!
Alright people, I'll try a different approach, i hope somebody can help me here:
As i explained I have Several Bins for my Histograms, 7 Temperature * 7 SOC Bins where each value is a time in minutes that car spent in that bin + an ID for a specific car from which the Bins came and the age of the car. (IDs can be reappearing with different ages)
I created a random table to show how it would look like(image there would be seven iterations of T and SOC):
What I'm trying to now is select the row where the age for each ID is max and read out all the bins.
Then i want to create a 7 by 7 by distinct count(ID) matrix where for each ID there is an entry with for every Temperature and an SOC.
This would enable me in qlikView to plot a 3D matrix over Temperature and SOC with only the IDs i selected.
I'd like to that in the Script. Is QlikView even able to do that?
I am able to do this in matlab by simply adding every max value to a certain field but I'm having serious troubles implementing that in qlik View.
Can anybody help me?
If thats not possible is there any other solution?
Like creating Dynamic Dimensions that replicate that order?
I was trying to use the crosstable function, but i always run into a wall at the point where i cant create a three or more dimensional matrix in QlikView.