Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kakaderanjit53
Creator III
Creator III

Calculate Monthwise CountOf No. of Orders

Hi Qlik Community,

I am new to qliksense,

I have to calculate the Monthwise CountOf No. of Orders by using data fromSQL server and data from QVD,

My tables are as follows:

PFA for the same, and help me for solving my query.

3 Replies
sunny_talwar

Would you be able to share a sample with expected output to help you better here?

kakaderanjit53
Creator III
Creator III
Author

Hi Sunny,

My Script is as follow for reconcillation of data from SQL server and QVD:

I have to display the

Trace     SQL_MONTH    QLIK_MONTH   NOOF_Count of Order_SQL   NOOF_Count of Order_Qlik   Order_Difference

kakaderanjit53
Creator III
Creator III
Author

Hi Sunny,

I got the solution of my problem,

thanks alot for your valuable time.