Conditional Values

[renuka_sasikumar]

I have cycle & Fiscyear

Now I dont want to show sales value only when current month is select other than its should show.

Even if i select 2013 year jan its show but when selecting 2014 jan its should not show

[PrashantSangle]

Hi,

Try like

if(MonthName(datefield)=monthName(today()),0,sum({<dateField={"=$(=monthName(max(dateField)))"}>}Sales))

Regards

[sunilkumarqv]

Try like according to your requirement

IF(getfieldselections(Year)='2014' and Getfieldselections(Month)='Jan',0,

sum({<dateField={"=$(=monthName(max(dateField)))"}>}Sales))

[renuka_sasikumar · Accepted solution]

Hi,

This is been resolved,

I have given condition in the layout when its max(FYear) and Max(Cycle) it should not reflect.

That time I was new in Qlikview

Regards,

Renuka S