topic Re: Showing month daywise in QlikView

Showing month daywise

deepakqlikview_123 — Mon, 28 Apr 2014 11:07:43 GMT

Hello Team,

I want to show month daywise for selection.

For eg Jan-1,2,3--31

Feb-1,2,--28

Mar-1,2,--31

Apr-1,2,--30

May1,2,--31

Till December 1,2,--31

Please find attached photo for this

Can you please suggest how shall i proceed.

thanks

Re: Showing month daywise

its_anandrjs — Mon, 28 Apr 2014 11:10:53 GMT

Try Like

Month&-&Day as MonthDay

Add fields in the load statement like

Load

Month(DateField) as Month,

Day(DateField) as Day

From location;

And Then take a pivot chart

Dimension:- Month

Diemnsion:- Day

Expression:- Sum(Value)

Re: Showing month daywise

tresB — Mon, 28 Apr 2014 11:12:02 GMT

Create additional field in the script using Day(), like:

Load

Date,

Month(Date) as Month,

Day(Date) as Day

Then, use a pivot table: Dim1: Month, Dim2:Day then your expression. Pull your second dimension to column.

Re: Showing month daywise

MK_QSL — Mon, 28 Apr 2014 11:12:15 GMT

Create Below in your script

Considering you have Date Field

Month(Date) as Month

Day(Date) as Date

Now Create a Pivot Table

Dimension

Month

Date

Expression

As per your requirements

Now Drag Day Field to the Right TOP

Re: Showing month daywise

deepakqlikview_123 — Mon, 28 Apr 2014 11:27:30 GMT

Hello Team ,

Thanks for reply but I would Like to show in below format

Jan	1	2	3	4	till	31

Feb	1	2	3	4	till	28

Mar	1	2	3	4	till	31

Apr	1	2	3			20

till


December	1	2	3	4	till	31

We are plotting line graph for detecting trend for that pupose for making day wise selection above is requirement.

Please suggest

Thanks

Re: Showing month daywise

its_anandrjs — Mon, 28 Apr 2014 11:30:53 GMT

Update

Try like

Month&concat(Day,' ')

Or Better way is use

Dimension:- Month , Day

Expression:- Sum(Value)

and click on the Day field and drag over right upper corner of the pivot table then you see the blue arrow mark when it is horizontal leave the Day field there then you get answer as you want try the trick.

Re: Showing month daywise

MK_QSL — Mon, 28 Apr 2014 11:32:29 GMT

Kindly provide sample data ....

Re: Showing month daywise

Mon, 28 Apr 2014 11:49:37 GMT

use two calculated dimension in pivot table: 1. month(Date), 2. day(Date) and the as expression use sum(value) (or whatever expression you have)

and then you have to drag the second dimension to the top

regards,

Re: Showing month daywise

deepakqlikview_123 — Mon, 28 Apr 2014 11:50:47 GMT

Hi Manish,

Please find attached image.as per requirement the need is to plot dimension on x axis month with date as mentioned above.

And on axes there is percentage of absetism .

I have year month and day fields in my table.

Thanks

Re: Showing month daywise

fernando_tonial — Mon, 28 Apr 2014 12:01:48 GMT

Hi, See the example.

Best Regards.

Tonial.

Re: Showing month daywise

deepakqlikview_123 — Mon, 28 Apr 2014 12:16:28 GMT

Hi Fernando,

Thanks for reply ur graph is very useful for me,can you please tell me how to plot second dimension is below the first dimension instead of showing it at corner in a line chart.

Thanks,

Re: Re: Showing month daywise

fernando_tonial — Mon, 28 Apr 2014 12:37:00 GMT

Hi,

With the active object, you must press CTRL + SHIFT, you'll see some red rectangles. Click the rectangle Legend of months and even with pressed CTRL + SHIT drag the legend to bottom of the chart.

Best Regards.

Tonial.

Re: Showing month daywise

Anonymous — Mon, 28 Apr 2014 12:37:51 GMT

Hi Deepak,

Use Shift+Ctrl in chart and drag the legend to bottom of graph.

Thank,

R N

Re: Showing month daywise

deepakqlikview_123 — Tue, 29 Apr 2014 04:46:28 GMT

HiFernando\Ravichandra,

Please find attached image,As per requirement I have to show both dimensions and on their combination there should be value below x axis moreover user also able to select multiple months to see the results as per his requirement.

Please suggest.

Thanks,

Re: Showing month daywise

deepakqlikview_123 — Tue, 29 Apr 2014 05:07:14 GMT

Hi all,

Thanks for reply ,Please find attachment as per requirement I need to show sum of values at the combination of both dimensions on x axis so that It is possible to select multople months at same time.

Can you please suggest.

Thanks,

Deepak

Re: Showing month daywise

deepakqlikview_123 — Tue, 29 Apr 2014 05:51:55 GMT

Hello Folks,

Any suggetion on this.

Thanks

Re: Showing month daywise

fernando_tonial — Tue, 29 Apr 2014 19:36:22 GMT

unfortunately you can not do this on the same chart, it is necessary to create another chart type table.

Re: Showing month daywise

deepakqlikview_123 — Wed, 30 Apr 2014 04:18:00 GMT

Hi Fernando thanks for reply but can u plz tell me how to proceed I mean which chart type shall i select and moreover how to show symbol as shown in graph.

Thanks

Re: Showing month daywise

SunilChauhan — Wed, 30 Apr 2014 04:32:39 GMT

combo chart shows symbols

like *,+,diamond ,Circle etc

Re: Showing month daywise

Fri, 31 Oct 2014 05:59:02 GMT

Hello Team

I need tone help. I need to create the report as following

Name	jan	feb	Mar	apr	May	June
N1	12	2	1	4	4	23
N2	12	2	2	3	5	3
N3	3	4	4	3	6	3

Can any one help me out how to do this and these data are comming from back end