3 Replies Latest reply: May 22, 2013 3:04 PM by Gysbert Wassenaar RSS

    Only one value in a dimension

    Iliyan Somlev

      Dear Community,

       

      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?

       

      Thanks.