topic Re: Qlik view Bar chart in QlikView

Qlik view Bar chart

Bharathi09 — Fri, 15 Nov 2024 21:00:40 GMT

Hello All,

I am very new to QV Environment, what below symbol means?

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

what highlighted part to in this case?
Help me

Thanks!

Re: Qlik view Bar chart

MayilVahanan — Mon, 03 Jun 2024 07:56:32 GMT

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

Re: Qlik view Bar chart

Bharathi09 — Mon, 03 Jun 2024 07:59:11 GMT

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?

Re: Qlik view Bar chart

MayilVahanan — Mon, 03 Jun 2024 08:07:36 GMT

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.

Re: Qlik view Bar chart

TauseefKhan — Mon, 03 Jun 2024 08:10:23 GMT

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

Re: Qlik view Bar chart

Bharathi09 — Mon, 03 Jun 2024 08:16:03 GMT

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?