topic Re: Count for a column per week wise in QlikView

Count for a column per week wise

Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

I required count of a column 'X' per week wise.

Column Name	20-1-2015	21-1-2015	22-1-2015	23-1-2015	24-1-2015	25-1-2015	26-1-2015
X	0	1	1	0	1	0	1

so i have given in the above table for one week details.

So when i click on this week 20-1-2015 i required output for "X" column count as '4'(here it should count all 1's for this week)

Thanks

Avinash

Re: Count for a column per week wise

Anonymous — Thu, 30 Jul 2015 07:18:43 GMT

if you use a straight table with two dimensions (X and week(yourdatefield))

and e.g. a listbox with your datefield and you select the 20-1-2015, the table will Show 4 in your case

alternatively you candefine a drill down Group with week and date, so you can drill as above and when you go up to week you will see your desired output

Re: Count for a column per week wise

Thu, 30 Jul 2015 07:28:36 GMT

Thanks For your reply,

We are using pivot table and here we have two selections DATE and WEEK check boxes.

So when i click on date check box the above mentioned table will be displayed, but when i click on week check box for the weekstart as '20-1-2015' and display in 'X' as 0.

Re: Count for a column per week wise

Anonymous — Thu, 30 Jul 2015 07:32:48 GMT

if you have the week defined with weekstart yiu will get 0 as Output. in this case you Need to use week(weekstart(yourdate). but you would not need weekstart only week(yourdate).

can you post small example qvw?