chart expressions

[#1]

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]

Hi

try some thing like below

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

[jyothish8807]

Hi Mafaz,

Try like this:

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

Regards

KC

[#4]

not working

[jyothish8807]

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

Regards

KC

[jagan]

Hi,

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

Regards,

Jagan.

[amit_saini]

Check this attachment.

Thanks,

AS

[SunilChauhan]

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

and go to chart properties->uncheck supreess zero values

[#9]

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