Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count funtion

Dear All,

I am a beginner in Qlik sense and want to use the following function but I am unable to do so.

Please help me in this regard.

Count(all [KomDatenService] like '*Huawei*'

And [Build_type] = 'new'

And [TOC] <> 'TOC Planung'

And [St82] is null

And [St790_Soll] is null

And [St790] is null

And [St930] is null")

Thanks

10 Replies
ogster1974
Partner - Master II
Partner - Master II

Something like this?

COUNT(ALL {<

Wildmatch([KomDatenService],'*Huawei*'),

match([Build_type],'new'),

not match([TOC],'TOC Planung'),

match([St82],null()),

match([St790_Soll],null()),

match([St790],null()),

match([St930],null()),

>}

<Whatever your counting>)

ogster1974
Partner - Master II
Partner - Master II

Heres a document to get you started on set analysis.

Not applicable
Author

COUNT(ALL {<

Wildmatch([KomDatenService],'*Huawei*'),

match([Build_type],'new'),

not match([TOC],'TOC Planung'),

match([St82],null()),

match([St790_Soll],null()),

match([St790],null()),

match([St930],null()),

>})

this expression is giving me error in expression

Not applicable
Author

I am using Text and Image to calculate the field

ogster1974
Partner - Master II
Partner - Master II

Replace whatever your counting with the field you are counting on you can't just remove it.

Not applicable
Author

Dear Andy,

Thanks for the kind support and sorry for the late reply.

I am using below script but still it is showing error in the expression.

COUNT(ALL {<

Wildmatch([KomDatenService],'*Huawei*'),

match([Build_type],'new'),

not match([TOC],'TOC Planung'),

match([St82],null()),

match([St790_Soll],null()),

match([St790],null()),

match([St930],null()),

>}

<Link_Rev>)

ogster1974
Partner - Master II
Partner - Master II

remove the <> around Link_Rev it should just be your field name.

Not applicable
Author

is it the same in Qlik Scene as well, because i am working in that.

Not applicable
Author

I have tried to figure out some thing which is mentioned below but the problem is with NULL values.

I am unable to count the values which are blanks.

count(distinct{$<KomDatenService={'*huawei*'},

Build_type={'new'},

TOC-={'TOC Planung'}

>}Link_Rev)