Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted
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

Highlighted
Creator III
Creator III

Hi Sunny,

I got the solution of my problem,

thanks alot for your valuable time.