Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

thonipad
Contributor III

Generic Date Object for Drill

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.



4 Replies
Not applicable

Generic Date Object for Drill

Can you send the application example?

thonipad
Contributor III

Generic Date Object for Drill

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.

Not applicable

Generic Date Object for Drill

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.

thonipad
Contributor III

Generic Date Object for Drill

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

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