topic Re: Conditional chart (plain table) output in QlikView

Conditional chart (plain table) output

Wed, 05 Feb 2014 13:46:51 GMT

I have a table of CID (Company ID), StartDate, EndDate (containing start and end of insurance contracts). My plain table chart should have a list of companies (CIDs) that don't have any insurance on a desired date (taken from a variable set by input box). I've taken CID as a Dimension and CID and

Count({$<[StartDate]={"<=$(TargetDate)"},[EndDate]={">=$(TargetDate)"}>}Distinct CID)

as Expressions. How can I limit the the counted expression to be displayed by the ">0"? And, by the way, what does "Conditional" oprion in expressions do? I failed to find any info in the manuals and could not understand the logic of setting it. Thanks in advance!

Re: Conditional chart (plain table) output

Gysbert_Wassenaar — Wed, 05 Feb 2014 14:09:10 GMT

The conditional option for expression is to add an expression that should return 0 to hide the expression column or any number other than 0 to show the expression column. It's used for example to let users choose the dimensions and/or metrics to show in a straight table. See this blog post for an explanation: Customizable Straight Table

If you want to suppress counts of 0 then enable the option Suppress Zero-Values on the Presentation tab of the chart. As long as you have only one expression in your chart this is enough to hide all CID's with a count of 0.

Re: Re: Conditional chart (plain table) output

Wed, 05 Feb 2014 17:32:27 GMT

What is the difference between "Conditional" on the Expression sheet and "Conditional" on the Presentation sheet?

I have the Supress Zero-Values set by default, but it doesn't hide zeroes on the chart. What am I doing wrong?

Is there a more general way to filter the values?

Re: Conditional chart (plain table) output

jaimeaguilar — Wed, 05 Feb 2014 17:43:38 GMT

Hi,

"Conditional" on the Expression sheet allows to hide or show just the expression you're applying a conditional. On the other hand "Conditional" on the presentation sheet lets you hide/show the entire object. So, basically the difference is the scope of conditional,

regards

Re: Re: Conditional chart (plain table) output

Thu, 06 Feb 2014 07:01:41 GMT

What do you mean by saying "...lets you hide/show the entire object..." ? What object? A whole chart? If so, it is doubtful as there are separate "Conditional"s on the Presentation sheet for each column. Each of them hide the respective column.

Re: Conditional chart (plain table) output

jaimeaguilar — Thu, 06 Feb 2014 15:55:20 GMT

What it means is that there are different levels or scopes for conditionals:

Conditional for sheets (tabs)
Conditional for objects (an object is a whole chart, straight table, pivot table, list box, etc)
Conditional for columns inside charts (for example you can hide or show just some columns of a straight table depending on certain conditions)

That's why the conditional option appears in different places, because they refer to different things,

hope that helps,

regards

Re: Re: Conditional chart (plain table) output

Tue, 11 Feb 2014 11:59:10 GMT

OK. But setting the Presentation/conditional does not hide the whole object (chart). It hides column only. You said: ""Conditional" on the presentation sheet lets you hide/show the entire object". What's wrong with my chart/hands/brain/etc? 😉

Re: Conditional chart (plain table) output

Tue, 11 Feb 2014 13:50:54 GMT

PARTIALLY solved for me: Chart Properties - Dimension Limits - (check) Restrict which values... - Show only values... (see screen attached). But I don't like the solution because it gives too little flexibility choosing the desired condition of showing/hiding records actually narrowed to only basic math operations. Is any way to alter it and have full featured condition? Something like "HAVING" clause in SQL.

Re: Conditional chart (plain table) output

jaimeaguilar — Thu, 13 Feb 2014 23:41:31 GMT

Yeah it was my mistake, the conditional that hides the whole object is located in layout tab:

Re: Conditional chart (plain table) output

rwunderlich — Fri, 14 Feb 2014 00:31:00 GMT

It looks like you have CID defined as an expression column as well? If so it will return a non-zero value. "Suppress Zero Values" only suppresses rows where all expression values are zero, whether those columns are hidden or shown.

(A column hidden on the Presentation tab still exists. A column suppressed by the Conditional property on the Expressions tab does not exist.)

-Rob

http://masterssummit.com

Re: Conditional chart (plain table) output

Wed, 19 Feb 2014 13:21:34 GMT

That does explain the difference, but unfortunately doesn't help me to solve the core problem.