topic Re: Set Analysis for Data Month in QlikView

Set Analysis for Data Month

joeychua — Sat, 16 Nov 2024 20:20:15 GMT

Hi All,

I am having trouble creating a set analysis to call out data from LasRefresh to 3 months back. There is no syntax error in the below expression but there is a Error in Calculation message shown. Please advise, thanks.

=MaxString(
{$<
[Date]= {">=$(=Date(addmonths(LasRefresh),'DD/MM/YY'),-12))"}
>}
[ID])

Re: Set Analysis for Data Month

miskinmaz — Thu, 01 Aug 2019 05:17:07 GMT

Instead of

[Date]= {">=$(=Date(addmonths(LasRefresh),'DD/MM/YY'),-12))"} with misplaced brackets

you can use

[Date]= {">=$(=Date(addmonths(LasRefresh,-3),'DD/MM/YY'))"}

Re: Set Analysis for Data Month

Lisa_P — Thu, 01 Aug 2019 05:30:34 GMT

Hi Joey,
Not sure about your LasRefresh, but you could try the ReloadTime() function like this:
=MaxString(
{$<
[Date]= {">=$(=addmonths(ReloadTime(), -12))"}
>}
[ID])

Re: Set Analysis for Data Month

jonathandienst — Thu, 01 Aug 2019 06:55:44 GMT

If LasRefresh is a field and has more than one possible value*, then the expression will not work. This called a 'naked field' as it is not enclosed in an aggregation (like Sum(), Avg(), Max(), ...) and QV cannot determine which value to use, so it returns null.