topic Re: Table Pivot/ Graph in QlikView

Table Pivot/ Graph

Fri, 07 Feb 2014 11:04:36 GMT

Hi! I create a pivot table where I count the number of days between two dates in a new field called “Days”, with a data selection.

I’d like to:

1) 1) Visualize the total of values of these fields in my table. How can I do it? Is a format data issue?

2) 2) Create a histogram with the total of each “Days” field in records of my pivot table, only where year is 2013. Maybe should I change the expression used in my pivot table to visualize the total of these fields?

Can you maybe help me with the example attached please?

Thank you for any help you can provide in this situation.

Regards,

Andrea

Re: Table Pivot/ Graph

kaushiknsolanki — Fri, 07 Feb 2014 11:15:12 GMT

Hi,

Do you mean that you want to count the numbers of Days between the End Date and Start Date?

If yes then kindly use below function.

Interval(EndDate - StartDate,'D')

Regards,

Kaushik Solanki

Re: Table Pivot/ Graph

Fri, 07 Feb 2014 11:19:02 GMT

The Networkdays () returns the number of working days (Monday-Friday) between and including StartDate and EndDate

networkdays ('2007-02-19', '2007-03-01') returns 9

Re: Table Pivot/ Graph

Fri, 07 Feb 2014 11:25:03 GMT

try this

=daystart(Date#('2/11/2013', 'DD/MM/YYYY')) - daystart(Date#('1/11/2013' , 'DD/MM/YYYY'))

Re: Table Pivot/ Graph

er_mohit — Fri, 07 Feb 2014 11:50:24 GMT

See the attached file

Re: Table Pivot/ Graph

Fri, 07 Feb 2014 19:31:21 GMT

Thank you for your help!

But I don't know how to create a histogram based on the total data calculated in my "Days" fields in the pivot Table.

I need to use this expression with these selections, but it doesnt work. Maybe I need to use/add another function in this expression to be able to create a histogram. Can you help me pls?

I really appreciate any help you can provide.

Regards,

Andrea

Re: Table Pivot/ Graph

Sun, 09 Feb 2014 10:26:02 GMT

Can anybody help me to create a histogram with the total "Days" field of my pivot table pls?

I really appreciate any help you can provide.

Regards,

Andrea

Re: Table Pivot/ Graph

Mon, 10 Feb 2014 16:37:44 GMT

Can anyone help me pls?