Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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

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

Creator III
Creator III

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

Creator III
Creator III

Hi Sunny,

I got the solution of my problem,

thanks alot for your valuable time.