Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hi
try some thing like below
sum(if(Month=month(today()),rangesum(ALLOCATION,-Actual_SAH,-PROJECTION),0)
Hi Mafaz,
Try like this:
if(Month=month(today()),sum(rangesum(ALLOCATION,-Axctual_SAH,-PROJECTION)),0)
Regards
KC
not working
Did you replaced the field name properly? There is spelling misrtake in my expression.
Regards
KC
Hi,
Attach some sample file so that it would be easier to give solution.
Regards,
Jagan.
Check this attachment.
Thanks,
AS
sum(if(Month=month(today()),rangesum(ALLOCATION,-Actual_SAH,-PROJECTION),0)
and go to chart properties->uncheck supreess zero values
Please check the attachement and kindly help me on that also QlikView formula error