topic Re: Background colour using expression in QlikView

Background colour using expression

ahmar811 — Mon, 18 Jan 2016 05:46:18 GMT

Hi All

I have pivot table with three dimension (Model, Month-Year, Product).I have a requirement to change the background colour using expression like

if(Model='PERSONAL CATEOGRY', OR Model='COMMERCIAL CATEGORY' OR Model='NOT MAINTAINED' OR Model='Total',RGB(163,245,268))

It works fine,but when I arrange my dimension in horizontal direction the above expression doesn't work.

Please refer above screenshot.

Kindly suggest some solution

Thanks & Regards

Ahmar Ansari

Re: Background colour using expression

robert_mika — Mon, 18 Jan 2016 06:50:22 GMT

maybe this will help

The second dimension... or how to use secondarydimensionality()

Re: Background colour using expression

ahmar811 — Mon, 18 Jan 2016 08:22:20 GMT

Robert Mika

Thanks for your response but it not work....

Re: Background colour using expression

marcus_sommer — Mon, 18 Jan 2016 08:31:49 GMT

I think there would be rather no way to access these header-column which is a kind of a help-column only to show the horizontal dimension. As a workaround you could use a second (dummy) expression maybe = '' and adjust the column-width to as small as possible (with a macro it could be nearly unvisible).

sub SetColumnWidth

set chart = ActiveDocument.GetSheetObject("CH17")

chart.SetPixWidth 3, 0

end sub

- Marcus

Re: Background colour using expression

dinuwanbr — Mon, 18 Jan 2016 08:34:18 GMT

Hi,

Are you able to upload a sample?

Rgds,

Dinu1

Re: Background colour using expression

ahmar811 — Mon, 18 Jan 2016 11:44:14 GMT

Thank you all

I got my solution by using macro which is

sub HideColumn

Call HideSubFunction("CH04",2)

end sub

private sub HideSubFunction(ch,n)

set ch=ActiveDocument.GetSheetObject(ch)

ch.SetPixWidh (n-1),0

end sub

Thanks & Regards

Ahmar Ansari