Qlik Community

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Valued Contributor

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
New Contributor

You could use set analysis to populate the calculatedsales column.

If you wanted to focus on the product, for example, and show amount of sales by date you could use a pivot table like the one below and replace country with code and city with date. You’d easily be able to see sales trends this way.0AB4E85C-9B13-4759-B2FB-9C6222BF857F.jpeg

 

0 Likes
57 Views