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: 
shahamel
Creator
Creator

order by expression - deadline this thursday

Dear QV-users,

I have a big problem,

I would like to transform this SQL qeury to a QV-expression to use wihitn a table or bar-chart

SELECT

     count(NUMMER_

FROM

A

WHERE

SUCCES = 1 AND

START =  SCHOOLSTART AND

DATE_EXIT < TODATE

ORDER BY

KWALIFICATION, COST, SIZE_EDUCATION, CONNECTION NUMBER,

I am able to create this formula, but it is essential for me to embed the order by statement within an expression to use in a table or bar chart.

I am yet NOT abel to do the part of order by.

any help on this short notice would me tremendously appriciated.

Gr. Sandeep

0 Replies