Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

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
Master
Master

Hi

Color coding should not influence pivot table

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

Regards

kuczynska
Creator III
Creator III

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.

beck_bakytbek
Master
Master
Author

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
Creator III
Creator III

Hi Beck,

Is it possible to post a sample QVF?

beck_bakytbek
Master
Master
Author

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