Count funtion

[#1]

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

[ogster1974]

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]

Heres a document to get you started on set analysis.

[#4]

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

[#5]

I am using Text and Image to calculate the field

[ogster1974]

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

[#7]

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]

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

[#9]

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

[#10]

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)