topic Generic Date Object for Drill in QlikView

Generic Date Object for Drill

Anonymous — Mon, 21 Jun 2010 16:06:07 GMT

I have one table which has the segment, funded_date, lost_date, new_date & amount. I want to display a simple table which has columns Segment, sum of funded amount, sum of lost amount & sum of new amount. The List box above should just display list of valid year and upon the click of a particular value, the values in all columns of table should change. How do I create this list box of date when this date needs to be associated to all the above dates?

Thanks,

Dinesh.

Generic Date Object for Drill

Mon, 21 Jun 2010 16:17:23 GMT

Can you send the application example?

Generic Date Object for Drill

Anonymous — Mon, 21 Jun 2010 18:44:33 GMT

I cannot send the application due to privacy concerns.

If you can point me in the right direction, I could take it from there.

Thanks,

Dinesh.

Generic Date Object for Drill

Mon, 21 Jun 2010 18:59:03 GMT

It can be something like this:


Data:
Load Segment, Date, DateType, Amount;
SQL Select ....;
Calendar:
load fieldvalue(Date, iterno()) as Date
autogenerate 1
while len(fieldvalue(Date, iterno()));
left join (Calendar)
load Date, year(Date) as year, month(Date) as Month, day(Date) as Day
resident Calendar;

Your chart may have:

- as Dimensions: Segment and DateType

- as Expression: sum(Amount)

In the list box you can have the Calendar filelds.

Generic Date Object for Drill

Anonymous — Mon, 21 Jun 2010 21:49:43 GMT

How can create LOAD statement like you mentioned from the below SQL statement?

SQL select segment, funded_date, lost_date, new_date, amount;