QlikView Set Analysis

[hlines_usacs]

Hello, Below is the set analysis expression we have in a QlikView chart. It had worked previously and now it is broken. I do not know exactly when it broke (ex: after an upgrade,etc.). The second expression does work after removing a field from the TOTAL.

Broken expression:

=if(

  sum(PUVisit_Count) > 0

  and

  sum({<

  [CPT Category]=

  ,[CPT Sub Category]=

  ,[CPT Group]=

  ,[CPT w Desc Ordered]=

  //,Ordering=

  >}

  TOTAL <Site,[Site Mnem]> PUVisit_Count) >= vPUMinVisitCount

  ,

  sum({<

  [CPT Category]=

  ,[CPT Sub Category]=

  ,[CPT Group]=

  ,[CPT w Desc Ordered]=

  //,Ordering=

  >}

  TOTAL <Site,[Site Mnem]> PUVisit_Count)

  ,

  Null()

)

Removing "Site" from the total makes the expression work:

=if(

  sum(PUVisit_Count) > 0

  and

  sum({<

  [CPT Category]=

  ,[CPT Sub Category]=

  ,[CPT Group]=

  ,[CPT w Desc Ordered]=

  //,Ordering=

  >}

  TOTAL </*Site,*/[Site Mnem]> PUVisit_Count) >= vPUMinVisitCount

  ,

  sum({<

  [CPT Category]=

  ,[CPT Sub Category]=

  ,[CPT Group]=

  ,[CPT w Desc Ordered]=

  //,Ordering=

  >}

  TOTAL </*Site,*/[Site Mnem]> PUVisit_Count)

  ,

  Null()

)

Any ideas as to why it was working, and then it stopped working? I tried adding in square brackets, copying and pasting the field name and some other things with no luck. Also, please do not ask me to share the qvw.

Any help is appreciated. Thanks!

[sunny_talwar]

But you are doing a TOTAL on both your dimension fields... which should be equivalent of having no TOTAL at all (unless I am missing something here).... Would you be able to share an instance when it was actually working? I am curious to see how it worked before so that I can help you with how it can work now