topic Filtering months with negative margin with a checkbox in QlikView

Filtering months with negative margin with a checkbox

oxiofrt — Mon, 27 Apr 2009 14:12:09 GMT

Hi,

I have a table by year / month. I have a margin for each month.
I would like to be able to filter 'in one click' all graphs in my application on years / months where margin is negative.

A check box entitled 'restrict on neagtive margin month' would be great.

The application herejoined is detailing the problem.

Thanks a lot for your help.

Filtering months with negative margin with a checkbox

Mon, 27 Apr 2009 14:39:40 GMT

There are several different ways to do this that depend on the data model and the situation. I used a calculated field to create a kind of "button" effect while avoiding macros or pre-calculation in the data model. To do this I had to create another field in your data table that combines the Year & Month.

Filtering months with negative margin with a checkbox

oxiofrt — Mon, 27 Apr 2009 15:11:32 GMT

Thanks a lot for your answer.
Ok for the method, does that mean in the application herejoined that I shoud create as many new fieldS as I have aggregation levels ?

Filtering months with negative margin with a checkbox

Mon, 27 Apr 2009 15:20:10 GMT

You would need to add a field to combine DT and Heure and use it in the AGGR() method. ANNEEMOIS can be ignored.

Filtering months with negative margin with a checkbox

Mon, 27 Apr 2009 15:40:04 GMT

You need to combine enough fields to match the level (granularity) of aggregation in the chart. Since you have the date, you do not also need the month.

Filtering months with negative margin with a checkbox

oxiofrt — Mon, 27 Apr 2009 16:47:25 GMT

Thanks a lot : -)