topic Re: set analysis in QlikView

set analysis

prrajendran — Sat, 16 Nov 2024 03:57:24 GMT

Hi Experts, I m trying to get 3 months figure in a column of a straight table. the dimensions in my table include date field. in my expression, i have to calculate the data received for 3 months from the selected month i.e, if i select January, my expression should calculate data received for Jan, Dec & Nov. my expression is in attachment. when i entered this expression and selected January, i m getting correct value in the expression but, my dimension date is showing date from november which is wrong. i just need the selected months' date to be displaying in the dimension. how can i do that. please help

Re: set analysis

dplr-rn — Thu, 04 Apr 2019 12:58:31 GMT

I think you have 2 toptions
- as of table
- a combination of aggr and range sum

check below link for an excellent article which should give you details of problems faced by you and solution approaches
https://community.qlik.com/t5/QlikView-Documents/Calculating-rolling-n-period-totals-averages-or-other/ta-p/1483033

Re: set analysis

prrajendran — Thu, 04 Apr 2019 13:20:23 GMT

can you please help me with the expression

Re: set analysis

dplr-rn — Thu, 04 Apr 2019 17:54:38 GMT

unfortunately i dont know details of your usecase or data model.
also if you go through the link you will see that possibly best option maybe a asof table which is a change in the data load script