topic Re: Conditional Values in QlikView

Conditional Values

renuka_sasikumar — Tue, 20 Jan 2015 07:53:53 GMT

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 — Tue, 20 Jan 2015 08:04:14 GMT

Hi,

Try like

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

Regards

sunilkumarqv — Tue, 20 Jan 2015 09:24:32 GMT

Try like according to your requirement

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

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

renuka_sasikumar — Thu, 03 Mar 2016 06:00:44 GMT

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