topic Re: Line chart - results evolution correct in QlikView

Line chart - results evolution correct

Wed, 01 Oct 2014 08:59:08 GMT

Hello everyone,

So I am trying to show on a line chart the evolution of some failures throughout some weeks.

My goal is to select one week and show on the line chart the evolution of the failures of that specific week trough the last 10/15 weeks.

For example:

I select week 38 and I have a top 5 of failures for that week. But the line chart only shows the current week selected.

If I select a larger number of weeks and detach my line chart I can show more week, but the failures I see correspond to the accumulated top 5 of those weeks.

How can I show the evolution of the failures trough the weeks?

I think I can achieve this with set Analysis but it does not seem to works the way I use it (expression of the line chart)

I have attached a application. I only have QV personal edition.

Thank you in advance.

Best regards

Re: Line chart - results evolution correct

Gysbert_Wassenaar — Wed, 01 Oct 2014 12:00:24 GMT

Try these:

10 weeks: Count({<DataTesteSCI={'>$(=date(max(DataTesteSCI)-70))'}>} distinct KNRSCI)

15 weeks: Count({<DataTesteSCI={'>$(=date(max(DataTesteSCI)-105))'}>} distinct KNRSCI)

Re: Line chart - results evolution correct

Wed, 01 Oct 2014 13:37:21 GMT

Hello Gysbert,

Thank you for the answer.

That actually works for the number of weeks

But I still have the problem of the evolution of the failures.

When I choose one week I still have the evolution of the accumulated results for all those 10 or 15 weeks.

Best regards.