Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
francisco_echev
Partner - Contributor
Partner - Contributor

Problem with a design in QlikView

Hi Guys,

I need design this report image.pngun Nprinting

 

 

 

 

 

 

 

The CANAL, SUBCANAL, TERRITORIO and PERIOD are dimensions, but the column INDICATOR no, (% pedidos no entregados a tiempo  and  % venta de pedidos no entregados a tiempo) are measured, also the ranges of <3, 3-6 .. > 21, is a calculated dimension, I need to make the design that is in excel (image above), in nprinting, but I can not alter the model, this model has a somewhat peculiar design, I attached the image I indicated that fields use.

image.png

For the calculation of  "% pedidos no entregados a tiempo" the field "ContadorNumeroPedidos" is added and for the calculation "% venta de pedidos no entregados a tiempo" the field "valor pedido" is added, my question is how can I do so those two calculations look like in excel, which seem to be dimensions.

Excuse my english, thank you very much.

 

 

 

 

 

0 Replies