topic formula in QlikView

formula

usercapricon — Mon, 26 Feb 2018 08:12:55 GMT

Hi,

I have this formula now can anyone please explain this

=SUM({<Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'},Month=,Day=,MonthYear=>}Amount)

why we wrote Month=,Day=,MonthYear=> ?????

Re: formula

jhoef-pv — Mon, 26 Feb 2018 08:37:40 GMT

Hi,

why we wrote Month=,Day=,MonthYear= ?????

ignores the current selection.

The expresion sum amount for Year={'$(vMaxYear)'},Date={'<=$(vMaxDate)'}. the value of the expression does not change with the selection MonthYear y Month.

Re: formula

usercapricon — Mon, 26 Feb 2018 08:59:53 GMT

will you please explain this also

Temp_Data:

LOAD

floor(rand() * 1000, 0.01) as Amount,

date(today() - rowno(), 'DD MMM YYYY') as Date

AUTOGENERATE (740);

Re: formula

jhoef-pv — Mon, 26 Feb 2018 09:36:39 GMT

Hi,

The function rand() returns a random number between 0 and 1.

Floor() rounds x down to the nearest multiple of step [+ offset]. The default value of offset is 0.

rowno: This function returns an integer for the position of the current row in the resulting QlikView internal table. The first row is number 1.

This table creates 740 records (autogenerate 740).

The values for Amount are between 0 and 1000.

The values for Date with format DDMMYYYY are between today-1 and 739 days before.

https://community.qlik.com/blogs/qlikviewdesignblog/2016/01/15/autogenerate-your-data