Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
shahamel
Contributor

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

Tags (4)