topic Re: Conditional statement in Chart expression !!!! in QlikView

Conditional statement in Chart expression !!!!

Tue, 01 Apr 2014 09:03:07 GMT

Hi,

I am trying to show the values in the column chart based on a conditional statement. But the expression is not working. Can anyone please help?

Below is the expression that i am using.

Sum({<Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}, Quarter=, [Question]={'Completion Rate'}>}

if([Total Responses]<=30,0,[Total Responses]))

Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}: This is defining the time period i.e. months across which columns would be computed i.e "Total Responses".

I want to show sum of "Total Responses" when is >30 else 0 should be shown for that month.

Re: Conditional statement in Chart expression !!!!

alexandros17 — Tue, 01 Apr 2014 09:09:36 GMT

the problem is surely related to this part of expression:

Date={">=$(DynamicMonthTrend6)"}*{"<=$(=Date(Max(Date)))"}

if you need a range just do:

Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}

Re: Conditional statement in Chart expression !!!!

Tue, 01 Apr 2014 09:18:32 GMT

This is also not working.

=Sum({<Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}, Quarter=, [Question]={'Completion Rate'}>}

if([Total Responses]<=30,0,[Total Responses]))

If i remove the conditional statement and define it as below then it is working fine.

=Sum({<Date={">=$(DynamicMonthTrend6)<=$(=Date(Max(Date)))"}, Quarter=, [Question]={'Completion Rate'}>}

[Total Responses])

Am i defining the conditional statement correctly?

Re: Conditional statement in Chart expression !!!!

Tue, 01 Apr 2014 10:16:46 GMT

The problem is that values across all the months are getting changed to 0. Instead i want to change the value only for those month for which it is <=30.

Re: Conditional statement in Chart expression !!!!

alexandros17 — Tue, 01 Apr 2014 10:20:12 GMT

can you post your documetn?

Re: Conditional statement in Chart expression !!!!

Tue, 01 Apr 2014 13:23:58 GMT

Got it resolved. Actually the data was <30 and also Zero suppressed option was enabled.

Thanks.