Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Color expression makes my pivot not selectable

Hi Folks,

i got a situation, i use 2 Dimension and 5 Expression in my Pivot-Table:

behind of my all expression i implement the RGB_Code like: if (Sum (...) > 95, rgb(102,204,0),rgb(255,255,255)), all my expressions do work well, but my dimension within my pivottable not selectable, i mean, nothing moves within my Pivot.

Has the color_expressioncode an influence on my pivot?

Does anybody have any idea?

Beck

5 Replies
brunobertels
Valued Contributor

Re: Color expression makes my pivot not selectable

Hi

Color coding should not influence pivot table

Coul you share your QVF or a sample of it with the pivot table ?

Regards

kuczynska
Contributor III

Re: Color expression makes my pivot not selectable

Hi there,

Are your dimensions calculated dimensions by any chance? I had this issue before and this was caused by me using calculated dimensions. Once moved to the load script and re-called in the chart as a standard dimension it was all back to normal.

beck110979
Valued Contributor III

Re: Color expression makes my pivot not selectable

Hi Michalina,

Thanks a lot for your Feedback, in my case i am using the normal dimensions (not calculated dimensions), only my expressions consists of variables.

Beck

kuczynska
Contributor III

Re: Color expression makes my pivot not selectable

Hi Beck,

Is it possible to post a sample QVF?

beck110979
Valued Contributor III

Re: Color expression makes my pivot not selectable

i try to create an simple example and will post it, because my actual examplen consists of customer data