topic Design question in QlikView

Design question

datanibbler — Fri, 19 Apr 2013 08:14:42 GMT

Hi,

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...

Thanks a lot for any help!

Best regards,

DataNibbler

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 09:58:50 GMT

Mit einer Pivot könnte man ein Chart wie in der ppt erreichen, indem man "leere" Formelspalten generiert, z.B. per = '' oder null() (in Tab Präsentation Anzeigen einstellen) oder bei richtigen Formeln like count(x) mit Schriftfarbe weiß auf weißen Untergrund oder ähnlich ...

Mehrzeilige Zellen gehen auch: sum(y) & chr(10) & sum(z) und im Tab Präsentation mehrzeilig wählen.

Alternativ wären dann noch mit mehreren Pivot/Textboxen ... zu arbeiten und diese zu überlagern - ist aber arg "fummelich" ...

Schöne Grüße

Marcus

Re: Design question

datanibbler — Fri, 19 Apr 2013 10:34:01 GMT

Hallo Marcus,

Danke erst mal für den Tip! Pivot-Tabelle mit leeren Zellen, das könnte gehen. Das wird wohl auch einigermaßen fummelig werden, denn die Abstände zwischen den Zellen sind ja nicht genauso groß wie die Zellen und ich denke mal, die Größe der Zellen, wo einfach so eine Dummy-Formel drinsteht, kann ich nicht wirklich beeinflussen, oder?.

Ich hätt eine andere Idee, aber auch die hat ihre Tücken: Das Layout als solches würd ich am einfachsten hinbekommen, wenn ich für jede Zelle ein individuelles Textobjekt anlege. Das wäre halt insofern tricky als ich dann überhaupt kein Diagramm hab, sondern alles in den Formeln machen muss - im Prinzip geht das, denn so eine Drilldown-Gruppe (ein einzelnes Element davon) ist ja grundsätzlich nichts anderes als eine Selektion. Ich müsste also in der Formel für jedes Textobjekt multiple Selektionen einbauen.

Dann könnte ich halt nicht das gleiche Sheet zur Anzeige verschiedener Ebenen benutzen, sondern ich bräuchte für jede mögliche Ebene ein Sheet, das zunächst versteckt ist und erst durch Klick auf die entspr. Fläche sichtbar wird, wobei gleichzeitig das andere verschwindet.

Gibt es noch andere Möglichkeiten, das hinzukriegen?

Danke vielmals!

Viele Grüße,

DataNibbler

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 11:18:55 GMT

Jede Formelspalte (bei separaten Formeln) kann individuell per Maus eingestellt werden. Ich denke, dass der Aufwand mit einer Pivot deutlich geringer ist, als sich mit Textboxen ein "Schachbrett" anzulegen und jeweils mit eigenen Inhalt zu bestücken.

Multiplen Inhalt kann man in der Pivot und auch in den Textboxen schon abbilden, einfach if(x, Formel 1, Formel 2) reinsetzen und per Variablen/Listboxen auswählen.

Schöne Grüße

Marcus

Re: Design question

kaushiknsolanki — Fri, 19 Apr 2013 11:35:25 GMT

Hi,

Have a look at the attached example.

Hope this is what you want.

Regards,

Kaushik Solanki

Re: Design question

datanibbler — Fri, 19 Apr 2013 12:15:08 GMT

Hi Marcus and Kaushik,

@ Kaushik

Yes, that looks somewhat like what I want - it corresponds with what Marcus is proposing I guess.

@ Marcus

Okay, if I can edit every individual column, then I guess that would work.

I could then use one of the columns for those traffic-light thingys.

Can I do the same with the dimensions? As you can see on the dummy_slide I have attached, there is a horizontal distance between the cells (which I could solve with empty formula_columns) and also a vertical distance.

Thanks a lot!

Best regards,

DataNibbler

Re: Design question

kaushiknsolanki — Fri, 19 Apr 2013 12:22:24 GMT

Hi,

Yes you can do so, but I am not sure about the proper method, but here is the example please have a look at the butterfly tab for a sample example of putting blank link at dimension level.

Regards,

Kaushik Solanki

Re: Design question

datanibbler — Fri, 19 Apr 2013 12:27:54 GMT

Hi Kaushik,

thanks for the help! I guess you won't believe it, but I just cancelled downloading your example because after about 30sec it was at 5kb 😉

Does putting in blank lines inbetween the dimensions really make it that much bigger (from 150k to 8.2MB)?

I will try again later.

Best regards,

DataNibbler

Re: Design question

kaushiknsolanki — Fri, 19 Apr 2013 12:32:46 GMT

Hi,

The application itself is a 8.2 MB.

If you dont want to download the Application, you will find it in your computer under

C:\Programfiles\QlikView\example\Document\Data Visualization.qvw

Regards,

Kaushik Solanki

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 12:33:29 GMT

Ja, wie von Kaushik vorgeschlagen, einen "Leerwert" in die Dimension packen. Am einfachsten wäre es vermutlich diesen Dimensionswert per Inlinetable an die Hauptdaten per concatenate ranzuhängen.

Schöne Grüße

Marcus

Re: Design question

datanibbler — Fri, 19 Apr 2013 14:01:00 GMT

Hi Kaushik,

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.

Can you give me a hint here?

Thanks a lot!

Best regards,

DataNibbler

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 14:06:16 GMT

It is an extra load-statement properbly per Inline and not a propertie in chart.

Schöne Grüße

Marcus

Re: Design question

datanibbler — Fri, 19 Apr 2013 14:21:02 GMT

Hi Marcus,

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?

Thanks!

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 14:40:16 GMT

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.

Schöne Grüße

Marcus

Re: Design question

datanibbler — Fri, 19 Apr 2013 15:08:16 GMT

Hi Marcus,

sorry, but I versteh immer noch nicht ganz 😉

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.

Best regards,

DataNibbler

Re: Design question

marcus_sommer — Fri, 19 Apr 2013 15:26:40 GMT

YourDataAsQVD:

Load * Inline [

MainAreas, Categorie, Value, ...more fields

Area1, Actual, 10, ...

Area1, Budget, 10, ....

....

];

concatenate

Load * Inline [

MainAreas, Categorie, Value

"", "", ""

];

Instead of empty values you could also use dummy-values and set the colour on transparent [argb(0,0,0,0)].

Re: Design question

datanibbler — Fri, 19 Apr 2013 15:34:03 GMT

Thanks for your patience 😉

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.

Re: Design question

Fri, 19 Apr 2013 19:35:06 GMT

Here something fairly close.

Re: Design question

datanibbler — Mon, 22 Apr 2013 07:19:05 GMT

Hi all,

hope you had a good weekend?

@ steve.nelson

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.