Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Weekly Activity Report

I am trying to create a weekly activity report and I am wondering how to create a chart and a table with the date field.  I am guessing I need to add the date fields of month, week and year in the script, but I am not sure how to do this.  I am also trying to filter out field values from certain columns in certain tables that i do not need to see in the report

Thanks

5 Replies
Not applicable

Could you please attach a sample QVW?  That would shed a lot more light onto the situation you're dealing with

Not applicable

Thanks.  I attached the qvw file

Not applicable

You're going to want to take a look at your data model first, you have a synthetic table in there and another table that is a "data island"  Once you take care of that and add in a date field to your data, you'll be able to make the objects to make your weekly report

Not applicable

How do I remove the $Syn 1 Table from my data model?  How did that get in the data model in the first place?

Not applicable

Here's a helpful post that may be able to assist you with that

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys