topic Re: Qlikview Randomly Changed Cell Formats in QlikView

Qlikview Randomly Changed Cell Formats

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am pulling data from a straight table inside my QV App. However, when I pull the data into an Excel sheet, it randomly changes the format for some cells one day, then it changes the format for another group of cells the next day. And on some days, none of the formats are changed. There is no order in which this occurs. I am not sure if this is a bug or do I need to change something inside my chart?

This is how the reports suppose to look once pulled from QV;

This is how it looks at random times

As you can see, the format has been changed randomly, some cells are highlighted in Blue and some have had their number formatting changed.

Re: Qlikview Randomly Changed Cell Formats

Thu, 16 Feb 2017 06:40:29 GMT

hI,

Did u check ur expression is having any background color expression or in visual cues tab.

if not did u applied any custom formatting cell for coloring

Re: Qlikview Randomly Changed Cell Formats

Thu, 16 Feb 2017 14:50:48 GMT

Hi Manoj,

Inside the visual cues tab, I only have rules for text colors, nothing for background. The style of the table is pyjama blue.