topic Re: SQL Scenario on historical data in QlikView

SQL Scenario on historical data

sujit_nath — Sat, 16 Nov 2024 02:31:40 GMT

SQL : I have 2 tables, one with current year data and othe with previous year data. Suppose current table is of 2018 and previous table is of 2017.

Fields are: Student Id, Name, Class, exam Type, subject, marks
I want to show the details of each student who got average marks less than 40 in previous year. What will be the query.

Re: SQL Scenario on historical data

Arthur_Fong — Tue, 10 Sep 2019 00:11:12 GMT

Is this the expected result?

For current year:

avg({<Year={'$(=max(Year))'}>}marks)

Last year with marks below 40:

avg({<Year={"$(=max(Year)-1)"},marks={"<40"}>}marks)

Thanks and regards,

Arthur Fong

Re: SQL Scenario on historical data

sujit_nath — Tue, 10 Sep 2019 04:23:39 GMT

Hi Buddy,

Thanks for your response and effort, however, I was looking for a SQL query to achieve this. I know this community is specific to Qlik, but would be helpful if you can help with the query.

Re: SQL Scenario on historical data

Brett_Bleess — Mon, 23 Sep 2019 15:02:11 GMT

Sujit, as you referenced in your reply, our forums are for Qlik products, in particular QlikView in this forum, you would be best off going to the Microsoft Communities in your case, or perhaps Stack Overflow or some other programming site, as I am doubtful you are going to get someone to write your SQL query for you here.

I did a quick Google search on SQL Query help and got quite a few hits, was not sure which one(s) may be of help, so going to let you run that yourself to see if you can find what you need, but I saw CodeAcademy as well as W3Schools hits showing up as well as quite a few others, so I believe you should be able to find what you need.

Regards,
Brett