topic Re: Calculated Column required. in QlikView

Calculated Column required.

varunvarma — Sun, 23 Nov 2014 05:36:42 GMT

Dear all,

Greetings for the day. Please guide to achieve below requirement. Please look below image.

I need to create new column "NEW SALES". Formula is mentioned in image. i.e. SUM(last 8 years sales)

Please support to achieve this. Thank you in advance.

deepakqlikview_123 — Sun, 23 Nov 2014 06:05:57 GMT

anbu1984 — Sun, 23 Nov 2014 06:18:17 GMT

Check this app

Dim: Year

Expr: Rangesum(Above(total Sum(Sales),1,8))

its_anandrjs — Sun, 23 Nov 2014 07:58:49 GMT

Hi,

Read this documents

Regards,

Anand

jagan — Mon, 24 Nov 2014 02:27:54 GMT

Hi,

Try like this

Dimension:YEAR

Expression: Rangesum(Below(total Sum(SALES),1,8))

Sort the Year in descending order.

Hope this helps you.

Regards,

Jagan.

jagan — Mon, 24 Nov 2014 06:45:56 GMT

Hi,

If you got the answer please close this thread by giving correct answer to the useful thread, it helps others in finding the answers.

Regards,

Jagan.