Hi,
I am doing month on month analysis and the data present on the database is completely in a de-normalized form for the quick access of data. This table has 400K records and more than 40 fields. I am currently working on Status field which is changed on monthly basis i.e. A or P or S. The denormalization is performed in such a manner that on monthly basis i have created a new field and update all the status on it. The field name is look like {Month}AP{Year} and I update it with each record status (A or P) monthly. I am facing problem while i am going to perform trend analysis on it.
Can I use these fields for the trend analysis (Line Chart) on QlikView.
