Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

Trellis

Hi folks!

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

Trellis.GIF

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

Br

John

12 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
johnan
Creator III
Creator III
Author

Alright, to my added expression?

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

sergio0592
Specialist III
Specialist III

Misplaced comma :

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

johnan
Creator III
Creator III
Author

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)

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
johnan
Creator III
Creator III
Author

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

Sorry, never use trellis before..

Trellis.GIF

johnan
Creator III
Creator III
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
johnan
Creator III
Creator III
Author

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