topic Re: Count Expression in QlikView

Count Expression

vikasgupta — Tue, 19 Mar 2013 09:41:32 GMT

Hi friends

I have following data set :

Name Id

01/01/13 02/01/13 03/01/13 ........ 30/01/13

abc

xyz

I wants to count total number of absent at particular date and name wise total number of absent from one month data set.

Thanks

Vikas

MayilVahanan — Tue, 19 Mar 2013 09:44:47 GMT

Use CrossTable and convert the data set into name, id, date and attendance.

Then you can convert date into month using month() function and u can achieve ur requirement

Hope it helps

kaushiknsolanki — Tue, 19 Mar 2013 09:50:35 GMT

Hi,

You need to use the CrossTab option.

Have a look at the QVW file and Excel file attached here with.

Regards,

Kaushik Solanki

jagan — Tue, 19 Mar 2013 09:51:45 GMT

Hi Vikas,

Try transforming this data to normal format by using CrossTable(),

Crosstable (Date, Status, 2) Load * from DataSource;

You can check help document for further help.

Hope this helps you.

Regards,

jagan.