topic Re: Multi box Values in QlikView

Multi box Values

Fri, 02 Aug 2013 16:40:35 GMT

Hi,

I am using an excel to develop reports.

I have column named 'week_ending _date'.

Values in the column are:

5/6/2011 12:00:00 AM

5/13/2011 12:00:00 AM

2/17/2012 12:00:00 AM

11/30/2012 12:00:00 AM

2/8/2013 12:00:00 AM

So, I have Weekly data from 2011 - 2013

From this I should create a Multi box Property but the values in the multi box should be-

Current week

Previous week

Current QTD

instead of the values which are there in data.

How do i achieve this? Can any one tell me the steps and query to achieve this?

I have attached the Sample excel.

Thanks in advance.

Re: Multi box Values

Anonymous — Fri, 02 Aug 2013 17:10:00 GMT

Try this.

Re: Multi box Values

Fri, 02 Aug 2013 17:22:11 GMT

Auto,

Thanks for the reply but i cant open the qvw file as I am using Personal edition.

Can you explain me the steps?

Thanks!

Re: Multi box Values

Anonymous — Fri, 02 Aug 2013 17:26:45 GMT

include this script in load...make sure to save the qvw in the same path as the excel file...or change the path in the script.

Re: Multi box Values

Fri, 02 Aug 2013 22:31:26 GMT

Thank You very much.

I am working on it now.

I need one more help. Plz see the attached image file. This is the demo 'Rx Sales' dashboard.

I want to create a pop similar to that, with the use of the script which u had given.

I was able to create a button and include the variable.

I am able to get the popup also.

But i want to display the similar kind of Popup with all the information together like Months, Week, Qtr with the heading Filter by Time.

Any idea on this?

Thank You once again.

Re: Multi box Values

Anonymous — Mon, 05 Aug 2013 14:11:34 GMT

The popup in the RX dashboard is simply a conditional display of objects (listboxes and textboxes). It is controlled with the button that is setting a variable value to satisfy or dissatisfy the display condition.

Just add listboxes and manipulate the settings to achieve the "popup" style that you want. Since you have the personal edition it will be difficult to illustrate this if it is unclear for some reason.

Re: Multi box Values

Mon, 05 Aug 2013 17:15:26 GMT

Thanks for the solution.

I have already developed the popup and the variable for the button but i wanted just the design "the outer layer".

I was wondering how to design the same way?

Plz see the attached image file.

Re: Multi box Values

Anonymous — Mon, 05 Aug 2013 17:20:19 GMT

Just create a textbox object with a white background where your want and set the layer(s) appropriately.

Re: Multi box Values

Mon, 05 Aug 2013 21:14:28 GMT

Thanks. I think you are correct.

I donot have the Rounded corners and Corner radius in Layout section of the button, may be because of the personal edition.

But i was able to bring in the complete solution apart from the borders as expected.

Re: Multi box Values

Mon, 05 Aug 2013 21:20:13 GMT

I want to restrict the line chart to 13 weeks.

Is there any option i can limit the dimension(Dimension Limits) in the tool or do I have to do it in query?

Plz find the attched qvw file for your reference.

Re: Multi box Values

Anonymous — Tue, 06 Aug 2013 13:53:18 GMT

Not saying this is the best solution.....but this will work.

name your original table 't1' and add the following to load script:

Load distinct

max(date) as d1,

date,

rowno() as sortnum

resident t1

group by date

order by date DESC

;

Add this expression to in your chart:

if(sortnum <= 13,sum(TEB))

Re: Multi box Values

Tue, 06 Aug 2013 15:19:56 GMT

Thank you for the solution.

But I achieved the solution by [sum(if(date>= date(today()-91), TEB))] expression.

Also, Please find the attached image file and excel.

I am having 2 products named X and Z in my excel.

and the values i am using are for the trend line is sum(TEB).

This [sum(if(date>= date(today()-91), TEB))] expression helped me to get the 13 weeks data for sum of both X and Z.

For the same query, I want to display 2 trendlines for X and Z.

How do i get this? Do I have to try with a if condition? (I want to keep this query also [sum(if(date>= date(today()-91), TEB))] in the condition.