here's a challenge I'm currently facing: I got three Fields (Code A, Code B, Wert) (Wert is German for value). The values in Code A und Code B a from the same co-domain, but from different sources (hence two fields). I need to compare the summed Wert for each distinct value from this co-domain depending on the source. The appended image serves as an example of what I'm planning to do.
Is there any way to get this done efficiently in Qlikview? Any help would be appreciated! Thanks a lot in advance!
I added an example QV document for you to modify and experiment with if required.
Thanks, a lot! This is the correct answer to the initial question. However, it seem like I forgot to add that there are various additional attributes associated with each row (like Year, see the updated, attached qvw).
Using your suggested solution will cause ignorance of selections being made. Right? Any way to circumvent this except for using additional attributes in the group by clause which isn't really efficient given the number of attributes I have got in my original application.
yes, your solution will work, but only with the minimal example. Whenever you get another Field in the INPUT table, you would need to add it to the computed table and the GROUP BY statement, which is very inflexible.