Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II

Qlik view Bar chart

Hello All,

I am very new to QV Environment, what below symbol means?
Bharathi09_0-1717400410471.png

='Part Desc = '&Concat(distinct [Part Description],',')------------this script is written inside it

what highlighted part to in this case?
Help me

Thanks!

Labels (5)
1 Solution

Accepted Solutions
TauseefKhan
Creator III
Creator III

Hi @Bharathi09 
PBI Measure:

PartDescConcat =
"Part Desc = " & CONCATENATEX (
VALUES ( 'YourTable'[Part Description] ),
'YourTable'[Part Description],
", "
)


*******Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.******** 

View solution in original post

5 Replies
MayilVahanan

Hi

It will display the "Part Description" value in the "Pop up" .

If there are more than one part description, it will display with comma separator.

For ex:

Part Desc = A,X,Y

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Bharathi09
Creator II
Creator II
Author

Thanks for replying,

Is it a measure?
If I want to add it in PBI, how can I do that and how can I show those values in bar?

MayilVahanan

Hi

Yes, it a measure.

In Powerbi, might be, use ToolTip page and create the Card object and use that page as tooltip in the bar chart.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
TauseefKhan
Creator III
Creator III

Hi @Bharathi09 
PBI Measure:

PartDescConcat =
"Part Desc = " & CONCATENATEX (
VALUES ( 'YourTable'[Part Description] ),
'YourTable'[Part Description],
", "
)


*******Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.******** 

Bharathi09
Creator II
Creator II
Author

Hello,

Thanks for giving measure how can I show it in PBI?, I have Total Amt measure also and other measure supplier desc as you have given in previous reply, when I hover on one bar it should give show total duty and supplier desc also

How's that possible?

Bharathi09_1-1717402533883.png