I am setting up a new Dashboard in QlikView. Right now, I'm puzzling with the GUI: It is supposed to display the values in what is a combination of hard-coded selections on the uppermost level (so that different parts of the data can be shown simultaneously) and Drilldown groups. I think I can do both. The difficult part is the look of it - I was supposed to get a Designer_training, but it didn't work our yet and I'm not yet proficient enough in designing.
I will attach a dummy ppt_slide to this post to show you how that is supposed to look: Basically, it's like a straight table, but with so much distance (in different colour) between the cells that it actually looks like a number of individual cells spread evenly over the page - I don't think I could do that straight away, just use individual cells displaying one value each? Well, maybe using text objects...
I have found that example file. It really looks like what I need - but I cannot find out in the properties dialog what has been done to introduce those blank lines inbetween the dimensions.
that is well enough - but in that document, I can see no Load statement at all!? There seems to be only one script tab, the "Main" tab with those standard settings...
Where did that all go?`
Regards,
DataNibbler
P.S.: I guess access is restricted in some way - whatever the IT_admins have set up in this company is very strange...
P.S.: To make it a bit more complex: How do I define the colour of those "inbetween_columns" I already have? I have a straight table, but neither in a straight table nor in a pivot table is there a "colours" tab in the properties dialog, so I need to insert that into my formula? How do I do that? I guess the RGB function is the right one and it's easy enough to use, but how to incorporate it into my formula?
Perhaps your demo-app is changed ... You can't find this empty row in the script then the load is from an excel-file, it is properbly simply an empty cell.
Put your required empty rows per Inline-Load an your data.
the base data for this document is taken from several qvd files - two for this object I guess. I know how to concatenate an inline table to the bottom of the table, but I imagine I need to group the corresp. table by [my dimension] and then introduce the blank lines inbetween the "groups" of values in this field?
Do I have a knot in my brain so that I am imagining the thing more complicated than it is? I know I tend to do that...
Thanks for helping!
I think once I have that object in place, I will try to somehow make it a standard, I can see that is going to look good as a Dashboard.
Okay, I can follow that - so that will provide me with an empty line appended to the bottom of the main data table. I still don't see how I can get from there to having an empty line inbetween every two values in my dimension field - but I will first try this and then get back to you.
Best regards,
DataNibbler
P.S.: Okay, that won't work - I built this in an existing document with a report and the table where the field I use as dimension comes from, where I'd have to concatenate/ append that blank line has approx. 100 fields... I will start by creating a copy of this document, renaming it, deleting my report from it, deactivating all but a few fields from that table and then try again.
Yes, that looks pretty exactly like what I want. Unfortunately, unless you have the script on hidden tabs, that was not downloaded.
But, unless I am mistaken here, you don't have empty rows or columns in your table? Those are something I absolutely need because I have to make them different in colour - like you have it actually, but I can't tell how you did that.
I have now deactivated/ commented all the fields I don't need - this is not going to be used for analysis, I suppose, so I don't need much - and appended an inline table with all the fields empty.
Now, when I look at the dimensions, there is an empty value.
But I still don't see how I can get from having an empty dimension_value to having a blank line inbetween every two dimensions?
Best regards,
DataNibbler
P.S.: I have now found a workaround - not perfect (that is the nature of workarounds 😉 but okay - it might prove problematic when the nr. of rows in my chart changes, but I think that can be avoided using the "limits" tab on the properties dialog?
I simply generate another textbox, completely white, and position that inbetween my dimension values - making the cells 4 rows high or so makes sure that the blank cell does not overlap the figures in the chart.
