Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression Syntax

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

1 Solution

Accepted Solutions
NickHoff
Specialist
Specialist

use set analysis:

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

View solution in original post

5 Replies
NickHoff
Specialist
Specialist

use set analysis:

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

View solution in original post

MK_QSL
MVP
MVP

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
Specialist
Specialist

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
MVP
MVP

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

Not applicable
Author

Thank you. My issue is now resolved