formula

[usercapricon]

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=> ?????

[jhoef-pv · Accepted solution]

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.

[usercapricon]

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);

[jhoef-pv]

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