topic Re: What does the stars in a set analysis statement mean? in QlikView

What does the stars in a set analysis statement mean?

Thu, 05 Jan 2012 10:44:45 GMT

Hi all,

I am quite new to qlikview.

I have made my first qlikview application and it shows sales for a specific month compared with that mont previos year.

What does the * after Year, Month and Year Week mean (I have highligthed them in red)?

sum({$< Year={"$(= max(Year)-1)"}, P_Counter= {"$(= max(PeriodCounter)-12)"} ,Year={"*"},Month={"*"},[Year Week]={"*"} >}

Best regards,

What does the stars in a set analysis statement mean?

Thu, 05 Jan 2012 10:49:31 GMT

hi you can try

Sum({<Annee={$(=Max(Annee))}>} Mont) / Sum({<Annee={$(=Max(Annee)-1)}>} Montant)

What does the stars in a set analysis statement mean?

Thu, 05 Jan 2012 10:55:24 GMT

Thank you for a fast reply!

But what do the stars really do if you describe it in words?

What does the stars in a set analysis statement mean?

swuehl — Thu, 05 Jan 2012 10:58:28 GMT

It's a wildcard.

So your element set for Year is equal to all possible values in field Year, same for Month and [Year Week].

hope this helps,

Stefan

Re: What does the stars in a set analysis statement mean?

Miguel_Angel_Baeyens — Thu, 05 Jan 2012 10:59:51 GMT

Hi,

Usually the "*" means "all values".

Sum({$< Year = {$(=Max(Year)-1)}, P_Counter = {$(=Max(PeriodCounter)-12)} >} SomeFieldHere)

In set analysis, that * means all possible values for the specified set, and usually you don't need to use them, because that's the default behavior, meaning it will take all values in Year and Month and [Year Week] regardless you specify the "*" or not.

Using quotes in set analysis is as well important, if a value is numeric, don't use quotes, otherwise QlikView will interpret all numeric values as literals taking longer than needed. You can read further on quotes and syntax in set analysis in the Reference Manual and in this post, among many others.

Hope that helps.

Miguel

What does the stars in a set analysis statement mean?

Thu, 05 Jan 2012 11:01:13 GMT

Thx, now I understand it!

What a great forum!