topic Re: Need Help?? in QlikView

Need Help??

Nagaraju_KCS — Mon, 01 Sep 2014 09:35:47 GMT

Hi Community

I have one requirement,

Example:

ItemCode	Des	Qty
100	XYZ	10
200	ABC	12
300	ASD	14
400	OOO	16

I want to create a Straight Table which will show ItemCode wise sum(Qty). But I want to show Desc of an ItemCode as ToolTip or any HelpText kind of things. Whenever a user hovers mouse pointer to a ItemCode cell, i want show popup containing description of the ItemCode needs to be shown.

is it possible in Qlikview?????

Thanks in Advance......

Re: Need Help??

Anonymous — Mon, 01 Sep 2014 09:42:37 GMT

I do not believe pop ups on hover are possible with straight tables, or any other type of table,

They are available for Charts objects line Bar and Line Charts.

Re: Need Help??

ashfaq_haseeb — Mon, 01 Sep 2014 09:43:58 GMT

Hi,

Its possible with Bar chart.

But With straight table I don't think this can be done.

Regards

ASHFAQ

Re: Need Help??

DavidFoster1 — Mon, 01 Sep 2014 09:48:11 GMT

An option is to create a calculated dimension that contains the ItemCode and Des, but restrict the width of the column to just big enouugh for the ItemCOde. When hovering QlikView would show the full field value in a tooltip/popup.

If you use something like =ItemCode & CHR(13) & Des then you will ensure that the description does not creep into view.

Re: Need Help??

Anonymous — Mon, 01 Sep 2014 09:52:39 GMT

Wow David. That is nicely cunning.

I take back my saying that it cannot be done.

Re: Need Help??

DavidFoster1 — Mon, 01 Sep 2014 09:53:38 GMT

It is crude but it works 🙂

Re: Need Help??

ashfaq_haseeb — Mon, 01 Sep 2014 09:57:14 GMT

Wow nice to learn

I take back my word.

Regards

ASHFAQ

Re: Need Help??

Nagaraju_KCS — Mon, 01 Sep 2014 10:56:48 GMT

how to show that, any other solution....?????

Please give suggestions.....

Re: Re: Need Help??

ashfaq_haseeb — Mon, 01 Sep 2014 11:01:17 GMT

Hi,

have a look at attached application.

Rehards

ASHFAQ

Re: Need Help??

Nagaraju_KCS — Mon, 08 Sep 2014 07:25:39 GMT

Hi ASHFAQ,

but i want show single line data

Example: When i move to mouse i want to show ItemCode, Desc, Avg in single line..

Anyone handled this type of issue..

please let me know.....

Re: Need Help??

DavidFoster1 — Mon, 08 Sep 2014 08:27:26 GMT

That kind of customisation is way beyond core QlikView. You would need to either write or commission an extension to achieve that kind of effect.

Re: Re: Need Help??

ashfaq_haseeb — Mon, 08 Sep 2014 09:33:54 GMT

Then,

Check if this helps.

Regards

ASHFAQ