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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Naitik
Partner - Contributor
Partner - Contributor

Valid Visualization

I have the following table of data:

PO

Value

Flag

Date

Month

420

100000

Scheduled

15-08-2021

Aug 21

420

30000

Delivered

05-10-2021

Oct 21

420

20000

Delivered

15-01-2022

Jan 22

420

35000

Delivered

17-01-2022

Jan 22

420

15000

Delivered

23-08-2023

Aug 23

 

I need to create a visualization that allows the user to select a specific scheduled month. Upon selection, the visualization should display the corresponding months when the deliveries occurred.

For the given PO, The planned delivery to be happen in month of Aug 21 but the actual deliveries are happened after the planned Month. therefore, Now, The user wanted to understand in a visualization, month wise total planned delivery value vs how it is being delivered ? (in percentages) for the entire company level.

Note: we have both planned and delivered values in the same table and preferred chart is Pivot Table.

Can anyone please advise on how to achieve this?

Labels (1)
0 Replies