Expression Syntax

[#1]

Dear experts

I would like to convert the statement below to qlikview expression syntax

Select Count(ID) From Table1 Where id_type between 501 AND 515

Please assists

[NickHoff · Accepted solution]

use set analysis:

COUNT({$<ID_TYPE >= {'501'}, ID_TYPE <= {'515]}>}ID)

[MK_QSL]

This is at the front end...

COUNT({$<id_type = {>=501<=515}>}ID)

This is at the front end (Script side)

Load ID,

        Count(ID)

Resident TableName

Where id_type >=501 and id_type <= 515

Group By ID;

[NickHoff]

If that is the front end just create the ODBC connection and use SQL.

Directory;

TableName:

LOAD ID,

ID_TYPE;

OLEDB CONNECT TO

SQL

SELECT

ID, COUNT(ID) AS ID_TYPE

FROM TableName

WHERE ID_TYPE BETWEEN 501 and 515;

STORE TableName INTO the qvd you want

[maxgro]

= count({$ <id_type ={">=501<=515"}>} ID)

[#6]

Thank you. My issue is now resolved