Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
kakaderanjit53
Contributor 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.

Tags (1)
3 Replies

Re: Calculate Monthwise CountOf No. of Orders

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

kakaderanjit53
Contributor III

Re: Calculate Monthwise CountOf No. of Orders

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

Re: Calculate Monthwise CountOf No. of Orders

Hi Sunny,

I got the solution of my problem,

thanks alot for your valuable time.