topic Re: chart expressions in QlikView

chart expressions

Tue, 25 Nov 2014 04:22:33 GMT

Hi All,

below is the formula am using for below chart. but I wanna show only data from current month past show go 0

how do I do it? thanks in advance

Sum(rangesum(ALLOCATION, -ACTUAL_SAH,-PROJECTION))

sasikanth — Tue, 25 Nov 2014 04:31:11 GMT

try some thing like below

sum(if(Month=month(today()),rangesum(ALLOCATION,-Actual_SAH,-PROJECTION),0)

jyothish8807 — Tue, 25 Nov 2014 04:37:25 GMT

Hi Mafaz,

Try like this:

if(Month=month(today()),sum(rangesum(ALLOCATION,-Axctual_SAH,-PROJECTION)),0)

Regards

Tue, 25 Nov 2014 04:40:02 GMT

not working

jyothish8807 — Tue, 25 Nov 2014 05:26:42 GMT

Did you replaced the field name properly? There is spelling misrtake in my expression.

Regards

jagan — Tue, 25 Nov 2014 05:27:46 GMT

Hi,

Attach some sample file so that it would be easier to give solution.

Regards,

Jagan.

amit_saini — Tue, 25 Nov 2014 05:31:12 GMT

Check this attachment.

Thanks,

SunilChauhan — Tue, 25 Nov 2014 05:35:55 GMT

sum(if(Month=month(today()),rangesum(ALLOCATION,-Actual_SAH,-PROJECTION),0)

and go to chart properties->uncheck supreess zero values

Tue, 25 Nov 2014 05:54:42 GMT

Please check the attachement and kindly help me on that also QlikView formula error