This content has been marked as final. Show 2 replies
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?