Solved: where claus - Qlik Community - 787806

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

hi,

i want to execute this request in a text object :

select count(field) where field='clos'

how can i do that in qlikview???

1 Solution

Accepted Solutions

Hi,

Try This one =Count({<field={'clos'}>}field)

HTH

Sushil

View solution in original post

4 Replies

Hi,

Try This one =Count({<field={'clos'}>}field)

HTH

Sushil

Count({$<field = {'clos'}>}field)

Author

think u

=Count(If(field='clos',field))