topic expression syntax in QlikView

expression syntax

ssriramin19 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a expression which calculates the Hit/ miss category using the below mentioned formula ,

=if([ABC Indicator]='A',IF(COUNT([Batch ID])>='20','HIT',IF(COUNT([Batch ID])<='19','MISS-U')),if([ABC Indicator]='C',IF(Count([Batch ID])<='12','HIT',IF(COUNT([Batch ID])>='13','MISS-O'))

IF([ABC Indicator]='B',IF(COUNT([Batch ID])<='10','MISS-U',IF(Count([Batch ID])>='24','MISS-O',IF(Count([Batch ID])>='11','HIT',IF(Count([Batch ID])<='24','HIT')))))))

Requirement is that I need to determine the count of the above mentioned expression . Like at the expression

after selecting the total count of the above mentioned expression the value turns out to be 355 ,like seen below

How to compute the value of total count of rows (value as 355 as highlighted) in the expression. How to modify the above mentioned expression to get the total count ,

I need this total count because I need to find the percentage of product sold.

Can you please suggest an approach for this .

Thanks

Sriram

Re: expression syntax

ssriramin19 — Mon, 14 Aug 2017 10:31:17 GMT

Can any one please suggest an approach for the above problem ?Kindly do the needful

Re: expression syntax

techvarun — Mon, 14 Aug 2017 10:32:32 GMT

Share a sample qvw file if possible

Re: expression syntax

ssriramin19 — Mon, 14 Aug 2017 10:40:19 GMT

Since the file size is large , I am unable to place the file here . I have copied the image of table and expression here.

I need to determine the total count of rows using the expression

Re: expression syntax

sunny_talwar — Mon, 14 Aug 2017 11:33:33 GMT

May be this

Count(Aggr(

if([ABC Indicator]='A',IF(COUNT([Batch ID])>='20','HIT',IF(COUNT([Batch ID])<='19','MISS-U')),if([ABC Indicator]='C',IF(Count([Batch ID])<='12','HIT',IF(COUNT([Batch ID])>='13','MISS-O'))

IF([ABC Indicator]='B',IF(COUNT([Batch ID])<='10','MISS-U',IF(Count([Batch ID])>='24','MISS-O',IF(Count([Batch ID])>='11','HIT',IF(Count([Batch ID])<='24','HIT')))))))

,YourChartDimensionsHereSeparatedByComma))

Replace YourChartDimensionsHereSeparatedByComma with the chart dimensions you have in your chart