Get last 6 month record from selected month number

[jayaseelan]

Hi Experts,

    I need to complete task, i have an data set which i have attached.. in that i have year, month number and qty as a column.

if i select the month number the sum of qty should show for last 6 months data from i selected month.kindly please reply me.

Thanks,

[balar025]

Hi,

Here is the General App for your last 3,6,12, Months of data. You can use same script in QlikSense.

Regards,

Ravi balar