topic Re: set analysis syntax not working in a new dasboard in QlikView

set analysis syntax not working in a new dasboard

ashishtams — Tue, 26 May 2015 11:02:55 GMT

Hi All

I have used a set anylysis syntax as below in the existing dashboard. This syntax works fine.

sum({$<[My Date]={"$(=date(MAX([My Date])))"}>}[total pass])

But now when i am trying to create a new dashboard and use the same syntax its not working. Just showing me '-' in all the rows instead of the data. I think i have checked all the other options in the properties for this expression but no no luck.

anybody faced the same issue or any idea on this would really help.

Thanks,

Ashish

Re: set analysis syntax not working in a new dasboard

stigchel — Tue, 26 May 2015 11:14:03 GMT

Then [My Date] probably is not a proper date. Try with

sum({$<[My Date]={"$(=Max(date(date#([My Date],'YourDateFormat'))))"}>}[total pass])

Re: set analysis syntax not working in a new dasboard

jonathandienst — Tue, 26 May 2015 11:15:38 GMT

One can only guess with the limited information you provided. The problem could be

[My Date] field does not exist, or is all null
[My Date] is not a proper date (so Max(My Date) does not work properly)
[total pass] does not exist, or is populated only with nulls
Something is wrong with the association in the data model between these two field and/or the dimension