topic Re: How to count? in QlikView

How to count?

Thu, 10 Dec 2015 05:54:35 GMT

Hi Community,

The below screen shot is my input,

I need the output as below,

I have tried with some expressions, but I could not succeed.

Can some one help me with this.

Thanks in Advance.

Re: How to count?

avinashelite — Thu, 10 Dec 2015 07:10:42 GMT

Could you please explain the LOGIC how your getting that output ?? so that we can help you

Re: How to count?

HirisH_V7 — Thu, 10 Dec 2015 07:26:31 GMT

Hi,

Can you please tell whats that count(on) and count (off) .

Table:
LOAD
Week(Date) as Week,
WeekStart(Date) as WeekStart,
WeekEnd(Date) as WeekEnd,
WeekDay(Date) as WeekDay,




 * INLINE [
    Date
    5/1/2015
   10/1/2015
    14/1/2015
    15/1/2015
    26/1/2015
    29/1/2015
    3/2/2015
    7/2/2015
    11/2/2015
];

Hope this helps for knowing week flow.

-Hirish

Re: How to count?

jagan — Thu, 10 Dec 2015 07:28:30 GMT

Hi,

Try like this

Data:

LOAD

Date AS ActualDate,

Date(MakeWeekDate(Year(Today(), OnWeekNumber), 'DD-MMM') AS Date,

1 AS OnCount

FROM DataSource;

Concatenate(Data)

Data:

LOAD

Date AS ActualDate,

Date(MakeWeekDate(Year(Today(), OffWeekNumber), 'DD-MMM') AS Date,

1 AS OffCount

FROM DataSource;

Now in chart try like below

Dimension: Date

Expression 1: Count of On

=Sum(OnCount)

Expression 1: Count of Off

=Sum(OffCount)

Hope this helps you.

Regards,

jagan.

Re: How to count?

raajaswin — Thu, 10 Dec 2015 09:20:34 GMT

I Think this is it.

Check the app

Re: How to count?

Tue, 12 Jan 2016 04:50:28 GMT

As 5th jan 2015 falls on week 2, 'count of on' should count only 2 in column 'on',

similarly 'count of off' should count 2 in the column 'off'. Here as there is no 2 in off column, the result will be zero(0).

Thanks

Re: How to count?

Tue, 12 Jan 2016 04:53:29 GMT

Yes that is the one. But if Iam trying the same by importing the data through excel, I could not get the exact output.