topic Data is aggregate for particular month in QlikView

Data is aggregate for particular month

prma7799 — Thu, 26 Nov 2015 05:19:51 GMT

Hi All,

We have one table in that we have used calculated dimension.

My question is I have product and it product have invoice date in the chart when I am taking calendar date range for one particular product the data is coming right but it is coming with aggregate format.

Say suppose product OBI-X have invoice date is 27-09-2014 then data should come from SEP to March but data is come only for Sep.

Thanks

Re: Data is aggregate for particular month

tresB — Thu, 26 Nov 2015 05:27:59 GMT

How does your expression look like? Could you share sample qvw?

Re: Data is aggregate for particular month

prma7799 — Thu, 26 Nov 2015 05:51:18 GMT

Hi tresesco‌,

Thanks for your quick response.

I got the solution I just remove all condition which was apply for all dimension.

=If(date([First Invioce Date],'DD-MM-YYYY')>=Date(vStartDate) and date([First Invioce Date],'DD-MM-YYYY')<=Date(vEndDate),

Product)

And simply apply above formula for First Invioce Date And get expected output.

Is anything else I will surly disturb you.

Many thanks