I'm making a Qlikview application that are based on two different data sets that have the same variable names. The difference between the datasets are, that they are compiled at different times of the year - one time a year and daily. The yearly data also has daily data in it, but only for the newest year (2014 for now), because the yearly data is compiled the 1st of october each year.
In the script I have concatenated the two data sets - and I can differentiate the data by a variable I created (datakilde), indicating whether the data comes from the daily data (Daglig) or from the yearly data (Aarlig).
I have a sheet which is based on the daily data and another one which is based on the yearly data. Because of this I had to make some expressions in my list boxes.
Example of a list box expression with the daily data:
As a result the current selctions box shows that the data comes from the daily data set (Daglig). I guess this is shown in the selections box, because of my expression - but I don't want the users to see which data that lies behind.
Can't it be done in a way, so it only shows the selection "Område" from the last list box and not what data is is??