topic Re: Conditional Show - Not behaving the way I expected in QlikView

Conditional Show - Not behaving the way I expected

Mon, 09 Jun 2014 11:46:17 GMT

Hi QlikView Experts,

I have a conditional statement for a text object

=pick(match(vBalancedScorecardComparitivePeriod,

'',

'Previous Day',

'Previous Week',

'Previous Month'),

if(sum({$<CalendarDate={'$(=Max(CalendarDate))'},CalendarDay=,Statistic={'Calls entered in Queue'}>}StatisticValue)=0,0,1),

if(sum({$<CalendarWeek={'$(=Max(CalendarWeek))'},CalendarDay=,CalendarWeekday=,Statistic={'Calls entered in Queue'}>}StatisticValue)=0,0,1),

if(sum({$<CalendarMonthAndYear={'$(=MonthName(Max(CalendarMonthAndYear)))'},CalendarDay=,CalendarWeek=,CalendarWeekday=,Statistic={'Calls entered in Queue'}>}StatisticValue)=0,0,1)

)

The text object keeps returning with a '-' even though I have a conditional show which when I test the output of each expression returns 0. So why then is this object not getting hidden. Please assist with what checks I can perform to identify what is causing this problem

Many thanks,

Byron

Re: Conditional Show - Not behaving the way I expected

Mon, 09 Jun 2014 11:48:48 GMT

Forgot to mention I have included an isnull statement as well. Still doesn't resolve the issue

Re: Conditional Show - Not behaving the way I expected

anbu1984 — Mon, 09 Jun 2014 11:52:17 GMT

Can you add sample app

Re: Conditional Show - Not behaving the way I expected

Mon, 09 Jun 2014 13:35:10 GMT

if(sum({$<CalendarDate={'$(=Max(CalendarDate))'},CalendarDay=,Statistic={'Calls entered in Queue'}>}StatisticValue)=0,0,1),

In the above expression, you do not need apostrophes in your dollar sign expansion. So:

if(sum({$<CalendarDate={$(=Max(CalendarDate))},CalendarDay=,Statistic={'Calls entered in Queue'}>}StatisticValue)=0,0,1)

This might be part of your problem. Also, are you sure-> '' is a possible value for vBalancedScorecardComparitivePeriod?

Re: Conditional Show - Not behaving the way I expected

Mon, 09 Jun 2014 13:57:03 GMT

Thanks for the replies Jacob and Anbu. I will post a sample or maybe just the whole object this evening.

@Jacob, old habits die hard I encapsulate all my dollar sign expressions in quotation marks. Removing does not fix the null error being returned.

With regards to is '' a valid value. It is because it is a hard coded delimited list which the user can select to get comparative information on different reporting periods

Cheers,

Byron