Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

josephinetedesc
Contributor III

Date Problem 1 week contains 2 months and a day with no activity

Hi all

How should I begin to solve this problem:

First of all there is a boundary problem on week 2015/05 -

Selecting January  -   no problem

Selecting February - no problem

So you select the month and the week will show the boundary dates  - so that is ok.

Capture.PNG

But there is a problem when a day has no activity - I am going to get the figures to show what I mean

3 Replies
sasiparupudi1
Honored Contributor III

Re: Date Problem 1 week contains 2 months and a day with no activity

please attach a sample

josephinetedesc
Contributor III

Re: Date Problem 1 week contains 2 months and a day with no activity

so the problem I believe is a philosophical one  - should the percentage used be shown as 11% or 109%?  The difference happens because if there is no usage then qlikView does not count the available minutes.  So instead of Machin2 being used for 60% of the time ie 300 mins of a booed for 500 mins, it is shown as  being used for 100% of the time. 

Capture3.PNG

How do other people solve this/show this???

Jo

josephinetedesc
Contributor III

Re: Date Problem 1 week contains 2 months and a day with no activity

cannot insert a file ... will try and send to you by email?

JO