topic Straight Tables and Mini Charts in QlikView

Straight Tables and Mini Charts

Thu, 24 Apr 2014 16:05:59 GMT

Hi,

I will try to explain this as best as I can, but its a bit complex.

I have a straight table with mini charts that work fine. The table shows data for a specific date selected and the minchart shows the trend for all the data.

This works fine, but my problem is that I have a rag field, which is either a 1 or a 2. In my staright table I only want to show data for measures that have a rag of 2 (for eample) for that month date selected, but still show the trend.

The problem is that it shows all the measures because of the trend. Because a measure may have a rag of 2 at somepoint in the past, and the minchart is showing all data for that measure, it still displays it in the table.

If I hide the trend it works fine.

Hope this makes sense, and I'm really hoping that someone has an answer.

I've attached a simplified version of my data.

Thank you in advance,

Simon

Re: Straight Tables and Mini Charts

Gysbert_Wassenaar — Thu, 24 Apr 2014 16:56:53 GMT

Try SUM({<Date,Measure={'=sum(Actual)>0'}>}Actual)

Re: Straight Tables and Mini Charts

Mon, 28 Apr 2014 09:16:51 GMT

Hi,

Thanks for your reply, with a bit of tweaking I got it working

CAn you explain what the set analysius does, am I right in thinking the Measure={'=sum(Actual)>0'} brings back any measures that are > 0?

I confused by this and never realised you could do that. Would this Actual={'>0'} be the same?

Cheers

Simon

Re: Straight Tables and Mini Charts

Gysbert_Wassenaar — Mon, 28 Apr 2014 09:59:44 GMT

Measure={'=sum(Actual)>0'} will select only those Measures where the sum of the Actual values is larger than zero. Actual={'>0'} is not the same. Try it.