topic Re: Set analysis in QlikView

Set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

See attached document showing two charts (and list boxes).

This simplified app aims at (with Set analysis) showing the sum of Belopp for respective Kategori as selected in table Val.

Why gives the expression sum({$<Kategori={Val}>}Belopp) with correct syntax "No data to display"?

The expression sum({$<Kategori=Val>}Belopp) with incorrect syntax gives the desired result.

BR, Hans Kaminsky

Re: Set analysis

sunny_talwar — Fri, 30 Jun 2017 18:18:50 GMT

Because you are comparing two fields... you can do this

Sum({$<Kategori=p(Val)>}Belopp)

Sum({$<Kategori=Val>}Belopp)

The syntax editor doesn't understand the syntax, but the expression in not incorrect.

Re: Set analysis

Anonymous — Fri, 30 Jun 2017 18:53:37 GMT

Thank you! I checked out the p() and e() functions, and they worked just fine! I knew that my expression was ok, but did not like that the text editor red marked the expression showing the syntax as incorrect. But by using the p() function all looks good 🙂