I have a simple question and I don't know if this can be done in qlikview, so please help me find out.
Please refer to the attached app. I have to show only one line for each CodeGroup in the straight table that has sum(Value) for an expression. But what is required also is that I have a column for the detailed Codes with drop-down menu. If I just add Codes as a dimension the lines will be multiple with detailed sum for each code, which is not what is wanted. There should be one line only with total sum(Value) for each CodeGroup.
I tried with aggr function but the dropdown menu doesn't show all possible Code values , it shows only the result of the aggr function.
Do you know if such match of grouped-detailed information is possible and what is the best way to visualise it?