topic request in QlikView

request

Wed, 19 Nov 2014 10:11:37 GMT

i want to execute this request in qlik:

select count(field_1) where field2='var1'

ashwanin — Wed, 19 Nov 2014 10:17:48 GMT

Hi,

Please try

Count({$<Field_2={'var1'}>}Field_1)

Wed, 19 Nov 2014 10:21:47 GMT

Try this if you want to do it in the script:

Load
count(field_1) as Count_Field1,
where field2='var1'
group by field2
;

Wed, 19 Nov 2014 10:25:10 GMT

Hi youssef

you can use the

count({$<field2={'var1'}>}Field_1) --if you use the static value.

if its a varaible then you should try

count({<field2={$(var1)}>}Field_1)

with regards

Harshita Gaur