topic Re: Trellis in QlikView

Trellis

johnan — Thu, 09 Nov 2017 08:47:45 GMT

Hi folks!

Ok, i have a Trellis with gauges. And now i want to present the amount in percent in the Trellis:

So i want a second expression with text. Is that possible?

John

Re: Trellis

Anil_Babu_Samineni — Thu, 09 Nov 2017 08:51:09 GMT

Chances are high using Dual('Text' & Sum(Sales)/Count(Name), Sum(Sales))

Re: Trellis

johnan — Thu, 09 Nov 2017 09:08:34 GMT

Alright, to my added expression?

sum(if(match(Status, 'FS','PK',), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

Re: Trellis

sergio0592 — Thu, 09 Nov 2017 09:13:57 GMT

Misplaced comma :

sum(if(match(Status, 'FS','PK',), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

Re: Trellis

johnan — Thu, 09 Nov 2017 09:17:13 GMT

Yeah, thanx, but i can't get the dualfunction to work with my expression:

Dual('Text' & Sum(if(match(Status, 'FS','PK'),Sum(Antal/Cs*KrtVikt) / sum(DISTINCT Vikt))

ORG:

sum(if(match(Status, 'FS','PK'), (Antal/Cs*KrtVikt)))/Sum(Distinct Vikt)

Re: Trellis

Anil_Babu_Samineni — Thu, 09 Nov 2017 09:31:23 GMT

Why not like this?

Dual('Text' & (Sum({<Status = {'FS','PK'}>} (Antal/Cs*KrtVikt))/Sum(DISTINCT Vikt)), (Sum({<Status = {'FS','PK'}>} (Antal/Cs*KrtVikt))/Sum(DISTINCT Vikt)))

Re: Trellis

johnan — Thu, 09 Nov 2017 09:44:29 GMT

Yes, working, but where can i see the "text"

Sorry, never use trellis before..

Re: Trellis

johnan — Fri, 10 Nov 2017 06:21:40 GMT

Hi maybe I was not clear enough?

i just want a text on my gauge that show the result in text in the gauge directly.
Now i have to sweep over with mouse to se the result

Br
John

Re: Trellis

Anil_Babu_Samineni — Fri, 10 Nov 2017 06:31:12 GMT

No, I am pretty clear about your intention. Fortunately i missed this conversation.

Anyway, Continuation is could be space is not enough though. Can you use Ctrl+Shift to check space enough for that text. If so, please elapse the space using mouse.

Second thought came to my mind, using "Text in chart" option from presentation tab

Re: Trellis

johnan — Fri, 10 Nov 2017 07:08:39 GMT

Hey, thanx but if i use text in chart it's only shows in the first gauge in my trellis

Re: Trellis

Anil_Babu_Samineni — Fri, 10 Nov 2017 07:12:57 GMT

Oh, I haven't tried this earlier. That's what my proposal is first one only. You can try the same if i have some thing like QVW or atleast software i may provide more in detail explanation how this works in single shot.

Anyway, Have you check the space concern of that text?

Re: Trellis

johnan — Fri, 10 Nov 2017 07:38:16 GMT

I see now that QV calculate the total, not in each trellis.. Bug?

Re: Trellis

johnan — Fri, 10 Nov 2017 08:05:30 GMT

With a little imagination, I fixed it in a different way