Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator 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
Master III
Master III

please attach a sample

josephinetedesc
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

JO