topic Grouping data (Not Field) with formula in QlikView

Grouping data (Not Field) with formula

shamsu_mk — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I have some data s example mentioned below table

Ac Amount BC

1 6000 CA

2 3000 CL

3 2000 CA

4 4000 CL

I need to calculate "CR" with the following formula

CR= sum( CA) / Sum(CL)

Thanks

Shamsu

sunny_talwar — Thu, 11 May 2017 15:38:26 GMT

May be this

Sum({<BC = {'CA'}>}Amount)/Sum({<BC = {'CL'}>}Amount)

shamsu_mk — Mon, 15 May 2017 05:59:27 GMT

Thank you, it worked properly

shamsu_mk — Sun, 18 Jun 2017 07:19:36 GMT

I need an additional support on the above query

I have a QlikView report as mentioned below.The column "change" shows the cumulative variance.

For example Change in CA, The value for May was 68 and June is 69. so the variance is 1

The script used calculate this as If(RowNo(TOTAL) = 1, 0, RangeSum([CA] - Above(TOTAL [CA])))

Since the script depends on the Rows I can not apply this expression in the chart.

I need a chart to show the change in Ca and Change in CL. Please help me.

Thanks

Shamsu

sunny_talwar — Sun, 18 Jun 2017 13:33:48 GMT

Would you be able to share a qvw sample to show the issue?

shamsu_mk — Tue, 20 Jun 2017 10:57:10 GMT

Yes, I will send.