topic Re: Set Analysis in QlikView

Set Analysis

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

Hi Everyone,

I have write one set analysis expression like below

=(SUM({<Category = {'Ateam'}>}[Foot Ball Team]))

(SUM({<Category = {'Ateam'},Test_Date={'$(=(Max(Test_Date)))'}>}Total_team))

But here category = Ateam is not applying properly. When I have selected Ateam from the list box only its showing the correct result.

The selection need to apply from set analysis. Please find the app and source file.Pleas let me know Am i missed anything.

Thanks

sunny_talwar — Wed, 13 Sep 2017 14:50:25 GMT

Try this

=(SUM({<Category = {'Ateam'}>}[Foot Ball Team]))

(SUM({<Category = {'Ateam'},Test_Date={"$(=(Max({<Category = {'Ateam'}>}Test_Date)))"}>}Total_team))

Anonymous — Wed, 13 Sep 2017 14:54:33 GMT

=(SUM({1 <Category = {'Ateam'}>}[Foot Ball Team]))

(SUM({1 <Category = {'Ateam'},Test_Date={'$(=(Max(Test_Date)))'}>}Total_team))