request

[#1]

hi

i want to execute this request in qlik:

select count(field_1) where field2='var1'

[ashwanin]

Hi,

Please try

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

[#3]

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

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

[#4 · Accepted solution]

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