topic Re: total count based on field value in QlikView

total count based on field value

Wed, 30 Apr 2014 06:57:10 GMT

I have table with which have a date.

I want to get the total from this table where the date belong to some year.

example get total for year 2014,

I want to use this expression

Re: total count based on field value

its_anandrjs — Wed, 30 Apr 2014 06:58:52 GMT

Write like

Sum({< Year ={'2014'} >} TOTAL value)

Re: total count based on field value

Wed, 30 Apr 2014 07:03:45 GMT

not clear,

can you give an example like

Table A has field YEAR,

the expression should return count of values where year = 2014

Re: total count based on field value

MK_QSL — Wed, 30 Apr 2014 07:04:10 GMT

Try Below Three... Any one should work;

SUM(Value)

SUM(Total Value)

SUM(Total <Year>Value)

Take Year and Dimension in Straight Table

And expression 1 or 3

Re: total count based on field value

its_anandrjs — Wed, 30 Apr 2014 07:07:47 GMT

Ex:-

Load * inline[

Year,Sales

2011,100

2012,150

2012,200

2014,400

2014,500

];

If you write expression :- Sum({< Year ={'2014'} >} TOTAL Sales)

Then you get line items of 2014 that is 900

Re: total count based on field value

Wed, 30 Apr 2014 07:08:35 GMT

SUM(Value), what value means

should I write SUM(2014)? if so it gives 2014

Can you give me a real example with Table A has field YEAR to get total count where YEAR = 2014

Re: total count based on field value

MK_QSL — Wed, 30 Apr 2014 07:10:22 GMT

SUM of Value means SUM(SalesPrice) or SUM(CostPrice) etc...

Re: total count based on field value

Wed, 30 Apr 2014 07:13:18 GMT

Will this will give sum of values for field Sales Price,

What I want is to the total records in table A where Sales Price = 1

Re: total count based on field value

anbu1984 — Wed, 30 Apr 2014 07:17:38 GMT

Count({< Year ={'2014'},Sales_Price={'1'}>} Sales_Price)