topic Re: Can qlikview manage this? in QlikView

Can qlikview manage this?

Thu, 25 Sep 2014 08:37:19 GMT

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!

Re: Can qlikview manage this?

tobias_klett — Thu, 25 Sep 2014 08:40:36 GMT

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

Re: Can qlikview manage this?

er_mohit — Thu, 25 Sep 2014 08:47:23 GMT

Try this for Line chart

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

Re: Can qlikview manage this?

israrkhan — Thu, 25 Sep 2014 08:51:12 GMT

yes possible,

can you please share a sample document..

would be easy to help...

Re: Can qlikview manage this?

sujeetsingh — Thu, 25 Sep 2014 08:53:26 GMT

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

Re: Can qlikview manage this?

Thu, 25 Sep 2014 12:10:30 GMT

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

Hope this helps.

Thank you!

Re: Re: Can qlikview manage this?

Thu, 25 Sep 2014 12:11:52 GMT

Hi Tobias,

I can't understand how to use set Analysis.

Here is a dummy sample of my app.

Could you help?

Thank you.

Re: Can qlikview manage this?

tobias_klett — Thu, 25 Sep 2014 18:14:55 GMT

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

Re: Can qlikview manage this?

Fri, 26 Sep 2014 08:29:35 GMT

Hello Tobias,

Should I keep the week in the dimensions?

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

Thank you!

Re: Can qlikview manage this?

tobias_klett — Fri, 26 Sep 2014 09:06:14 GMT

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.

Re: Can qlikview manage this?

Fri, 26 Sep 2014 09:57:14 GMT

Hi Tobias,

So with your help I am using Count({<Week=>} distinct KNRSCI) , but I think I still have the same problems.

I want to select one week, for example week 38, for this week I get a top 5, after this I want to show the evolution of this specific top 5 since week 28 till week 38. But what I get is the evolution of the top 5 of those 10 weeks...

Attached there is the file with I have acomplished so far.

Do you think Count({<Week=>} distinct KNRSCI) is what I need or do you have any other idea?

Thank you for the help!

Best regards.