topic Re: Selection in Pivot table in QlikView

Selection in Pivot table

soha1902 — Thu, 13 Aug 2015 04:34:06 GMT

Hi All,

I am displaying some product and there images in Pivot Table like this:

Now when I select any particular product image I want font should be bold and color for that particular product name should be change.

How can I do this?

Thanks in advance.

Re: Selection in Pivot table

sunny_talwar — Thu, 13 Aug 2015 04:37:59 GMT

May be on a selection the pivot table hides and then a text box with your required formating shows up?

Re: Selection in Pivot table

soha1902 — Thu, 13 Aug 2015 05:26:37 GMT

I already wrote this expression in table

Only({1}Path)

So if I select any particular image then it is showing all the images as well.

I just want to highlight the selected image and its name (either one or both).

Please help me regarding this.

Re: Selection in Pivot table

soha1902 — Thu, 13 Aug 2015 05:41:06 GMT

Any Help???

Re: Selection in Pivot table

jafari_ervin — Thu, 13 Aug 2015 05:43:50 GMT

Dear Soha,

You can use from Text Format option under your expression and dimensionm Like image below:

Please see the attachment.

Re: Selection in Pivot table

sunny_talwar — Thu, 13 Aug 2015 05:43:58 GMT

Not sure how you would highlight the image, but may be you can use a different formatting for the text part. Let me test some ideas and get back to u.

Re: Selection in Pivot table

sunny_talwar — Thu, 13 Aug 2015 05:45:07 GMT

I was thinking on similar lines, glad you saved me the trouble of working on it

Re: Selection in Pivot table

jafari_ervin — Thu, 13 Aug 2015 05:55:17 GMT

your welcome

Re: Selection in Pivot table

soha1902 — Thu, 13 Aug 2015 06:10:24 GMT

Hi ervin,

thanks for your reply.I am using Personal Edition so not able to open your qvw. can you plz let me know variable "V_selection" what expression you wrote?

Re: Selection in Pivot table

jafari_ervin — Thu, 13 Aug 2015 07:33:21 GMT

Hi Soha,

I used below expression in "V_selection" variable:

"V_selection" = =GetFieldSelections(Dim)