Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using different periodic dates?

Hi all, I am new to qlikview and really enjoying it.

I am just stuck on logically how to work with data for different dates.

Basically i have set up a report that displays all data on a portfolio as of the end of the previous month. The viewer can then choose which month they would like to see (list box - "only one selected value"). This is very basic and works fine. Now i want to create a tab that shows trending of the data over the previous months. How can i do this without changing the "only one selected value" on the list box etc, as this effects all the previous tabs?

As a stop gap, in the load, i reloaded the same dataset for periodic dates separately but gave all the fields different names so it didnt interfere with the other data. I am just wondering is there an easier way to do this as i am basically loading the information for each date separately which is very wasteful and confusing, considering the dataset is the same for each month. Hope this makes sense?

2 Replies
IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Welcome to QV world. Have you explored using Set Analysis? I am sure this is possible with Set Analysis. I am attaching a pdf document to learn Set Analysis. Please post your QV document with sample data and I would definetly try to help you.

Cheers,

DV

Not applicable
Author

Thanks very much for that D V. I haven't looked at set analysis yet but i will try it now. I will tell you if i get stuck!!