Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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