How to get billing days from two different tables?

Anonymous — Fri, 10 Jul 2015 07:56:17 GMT

Hi Everyone,

I have two tables A and B each of which containing dates. The Table A has dates for the year 2013 and 2014 and whether a day is billing day or not in that year ( represented as 0 or 1) as Billing Day field. The table B has Country names and other data. Table C has dates for the year2013, 2014 and 2015 and other data. I have taken two list boxes, one for Month and one for Day as inputs.

The list boxes are from table B and when the month and day from the list boxes are selected,

1. the total no. of billing days year wise

2. the no. of billing days from start of each year to the selected date in those years has to be displayed.

The output required is something like this:

Date Selected: Feb 2

Country Year Total Billing Days Bill Days till date

USA 2013 253 23

USA 2014 253 22

USA 2015 - -

Canada 2013 252 23

Canada 2014 252 22

Canada 2015 - -

PR 2013 - -

PR 2014 - -

PR 2015 - -

CR 2013 - -

CR 2014 - -

CR 2015 - -

Message was edited by: uday p

Re: How to get billing days from two different tables?

Gysbert_Wassenaar — Fri, 10 Jul 2015 08:23:25 GMT

See attached qvw.

topic How to get billing days from two different tables? in QlikView

How to get billing days from two different tables?

Re: How to get billing days from two different tables?