Can qlikview manage this?

[#1]

Hello everyone,

So I think I have a tricky problem to solve.

I will explain:

I import some data from a oracle database to my qlikview application.

With this data I have to make 2 charts: a bar chart and a line chart.

On the bar chart I show a TOP 5 of specific problems.

This TOP 5 change according to the date I choose, this means if I choose one week I have the accumulated results on that week. If I chose two weeks I have the accumulated results of those two week and so on.

I would like to show on the line chart the evolution of this results throughout the last 15 weeks. In other words, I need to show on the line chart the evolution of my TOP 5 (of the bar chart) trough the last 15 weeks.

But If I select two weeks of results, I only have two weeks of evolution on the line chart.

In attachment there is a picture that show the current state of things. In resume, the objective is that the line chart shows the evolution of the results of the TOP 5 (of two weeks) trough the last 15 weeks.

Is this possible to do on qlikview?

Best regards!

[tobias_klett]

Hi,

use set Analysis on your line Chart Expression:

Count( {<Week=>} Failurefield)

On Dimension Limit tab you can choose the Top5 of the FailureDimension

Hope this helps

Tobias

[er_mohit]

Hi

Try this for Line chart

Your expression for week wise and divide it by sum(Total {1} your expression field)

[israrkhan]

yes possible,

can you please share a sample document..

would be easy to help...

[sujeetsingh]

Just download some demo files from the site and you can easily explore .

[#6]

Here is a dummy sample of the app, it took some time to mimic the data.

Hope this helps.

Thank you!

[#7]

Hi Tobias,

I can't understand how to use set Analysis.

Here is a dummy sample of my app.

Could you help?

Thank you.

[tobias_klett]

Hi,
you should create the week field in the script instead of using a calculated dimension.

[#9]

Hello Tobias,

Should I keep the week in the dimensions?

Or should I use "Count( {<Week=>} Failurefield)" on the dimension?

Thank you!

[tobias_klett]

Hi,

once you have the field Week, Keep it in the dimension and use this as expression:

Count({<Week=>} distinct KNRSCI)

Because any field in the set Analysis Statement without a value after the "=" will ignore the selections made by the users.