I'm building up several dashboards in one qvw file. For one of them, I'm using dataset A, but for the other ones, I'm using dataset B. Just wondering whether there is a way to specify which dashboard is using which dataset in script, please?
You can use alternate states for that so every dashboard (I guess you mean a sheet with charts on it by dashboard) is on a different state. But generally, if you have 4 completely different data models, then you should definitely separate them in separate qvw
Thank you very much for your reply. However, this is not what I mean. Why I was asking this is that I'm actually using two similar datasets but with one of them (dataset B) I'm going to do CrossTable before it can be used for one of the dashboards. So that for this particular one, most of the field names are the same as the other dataset (dataset A). However, since the CrossTable is going to double count the other fields which may mess up the other dashboards which are using dataset A. So I'm wondering whether there is a way to say that dataset B is only used by that specific dashboard but all the other dashboards are using dataset A?
there is no good way to do that, unless you completely split the two tables (no links between them or between the dimensions) and use alternate states in your front end. Totally not recommended though.
no need to. concatenate means creating one table out of two. There is no need to change names in columns. QlikView will put same name columns together and the rest with null values were no common column name exists. For example
columns A, B
columns A, C
if you concatenate, the result will be :
columns A, B, C
with null values in column C for table 1 rows and with null values in column B for table 2 rows
If two tables that are to be concatenated have different sets of Fields, Concatenation of two tables can still be forced with the Concatenate prefix. This statement forces concatenation with an existing named table or the latest previously created Logical Table. A concatenation is in principle the same as the SQL UNION statement, but with two differences: first that Concatenate prefix can be used no matter if the tables have identical field names or not; and secondly that no removal of identical records are made.
CrossTable function will change the dataset structure and that's why I can't just simply use only one dataset.
Please find attached my sample tables. So in principle, I want to use the top table for most of my dashboards, but the bottom table (after CrossTable) for only one of the dashboards. For the only one dashboard, I'm plotting Development against DevPeriod for each UWYear. However, if I use the bottom table for other dashboards, all the other fields eg sales and countries will be multi-counted for every UWYear.