Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How can I count rows with column values selected from a another list

I have created a list containing years and another containing months. Excel containing three different date columns.

When I select a year or a month (or both) from a list report has to count number rows found for those 3 columns.

Data (DD.MM.YYYY):

Id     |     Column1     |     Column2     |     Column3

---------------------------------------------------------------------------

1          01.01.2013        02.02.2013       03.01.2013

2          01.01.2013        01.02.2013       03.02.2013

Situation1:

When I select a year (2013) > report shows value 2 for all of those fields.

Situation2:

When I select a month (02=february) > report shows value 2 only for col2 and 1 for col3 fields.

Situation3:

When I select month (01=january) and year (2013) > report shows value 2 for col1 and 1 for col3 fields.

3 Replies

Re: How can I count rows with column values selected from a another list

Cuold you provide the source tables?

manideep78
Valued Contributor

Re: How can I count rows with column values selected from a another list

Could you please provide any sample data? how exactly your source tables look like???

Not applicable

Re: How can I count rows with column values selected from a another list

Excel document in attachments

Community Browser