Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Ari_vzla
Contributor III
Contributor III

Getting wrong info

Hi, 

   I am trying to get a graphs counting values, my dimension is dates, each date is repeted a lot of time, en the value to count is Qty Pickeadores. After count values, I need divided the days of the month (but using my calendar no the regular calendar). I am using a networkdays to count the days. 

I am using 

=Count([Qty pickeadores])/NetWorkDays(Min([NewCreationDate]),Max([NewCreationDate]))

 Note: I need the information per month

But, the values is different for each month, Oct 2020 show me the correct information, but dic 2019, Aug 2020 and Sep 2020 show me information that I dont know is from where. 

The values that I am getting are 633 in Aug, 869 Sep

I though it is happened because I have some table with the same name, and I create new field to avoid issues, but I am still have issues.

 

 

 

 

2 Replies
Vegar
Partner
Partner

Could you show us what you are trying to do with that excel file  in an qlik sense file? I have trouble mapping your description to the content of your file. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Ari_vzla
Contributor III
Contributor III
Author

Sure, I want to do a graph with  the below values, these values are getting from the data contain the the excel file KPI almacén Arieli2 tab picks per day. 

If I created a pivot table in excel I got below result that it is the result that I need graph, but I am not sure with I am getting the values included in the graph attached. I guess  it is because I have field with the same  (Creation date for kitting time and for picks per day), so I created I new field called New Creation date but I still have the same issue.  I am not sure how can I solved?

 

This is as I need ghaphs

KPI_Almacén_KPI_Almacén_FY2020_Hoja_Qlik_Sense.png

 But, I am getting below ghaph

Graph.png

KPI_Almacén_Visor_del_modelo_de_datos_Qlik_Sense.png