Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
qlikview979
Specialist
Specialist

Hi Team,

I have show today date data  into yesterday date.Can you please help me on this  and My data like this

LOAD * INLINE [

DATE, TYPE , NUMBER ,CODE,SALES
29-09-2016, BE, 3337, W7011, 50
29-09-2016, BE, 3338, W7011, 50
29-09-2016, BE, 3337, W7022, 50 
29-09-2016, BE, 3338, W7022, 50
29-09-2016, BE, 3339, W7022, 0
30-09-2016, BE, 3337, W7011 70
30-09-2016, BE, 3338, W7011 70
30-09-2016, BE, 3337, W7022, 60
30-09-2016, BE, 3338, W7022, 70
30-09-2016, BE, 3339, W7022, 0 

];

 

OUTPUT should be below:-

 

DATE TYPE  NUMBER CODESALESCalculatedSales
29-09-2016BE3337W70115070
29-09-2016BE3338W70115070
29-09-2016BE3337W70225060
29-09-2016BE3338W70225070
29-09-2016BE3339W702200
30-09-2016BE3337W7011700
30-09-2016BE3338W7011700
30-09-2016BE3337W7022600
30-09-2016BE3338W7022700
30-09-2016BE3339W702200

 

 

Regards

Mahesh

Tags (1)
1 Comment