Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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

Tags (1)
1 Solution

Accepted Solutions
NickHoff
Valued Contributor

Re: Expression Syntax

use set analysis:

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

View solution in original post

5 Replies
NickHoff
Valued Contributor

Re: Expression Syntax

use set analysis:

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

View solution in original post

MVP
MVP

Re: Expression Syntax

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
Valued Contributor

Re: Expression Syntax

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

MVP
MVP

Re: Expression Syntax

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

Not applicable

Re: Expression Syntax

Thank you. My issue is now resolved