Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Add one more expression which shows the Data for previous date.
Now you need one more expression which will show Column(1) - Column(2)
Thanks
So, you mean to say for each business day, you are creating one dashboard or what?
Don't you store data of previous business day?
If any one have to check data for 30 Dec, how will he check?
Ok, in that case you need to load the data from both the QVDs ( Current Day and Previous Day) in your new Dashboard.
Then fetch the required columns from one concatenated table.
ok
Please note down the steps,
Plz create 2 variables which will have current business day and Previous Business Day Details.
Now, based on the variable plz load both the qvds - Business_QVD_$(v_Current) and Business_QVD_$(v_Previous).
Since both the qvds have same columns, it will get autoconcatenated.
Now you can get your required data from that final Table.