topic Re: Bold Text format for dim & Exp not working for null or zero values in QlikView

Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 07:01:28 GMT

Hi,

I have a Pivot table with 4 dimensions and one measure.

For both these, i have provided text format to display as bold '<B>' with the condition -

if(Region= 'Total','<B>')

But wherever the expression value is zero or Null, the bold does not work, and it shows in normal font.

I am expecting a result like this, but the result i am getting is - For Column A, wherever there is 0 or null, the value is not bold but normal format.

Thanks

Re: Bold Text format for dim & Exp not working for null or zero values

senpradip007 — Wed, 10 May 2017 07:12:32 GMT

Please share the sample qvw.

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 07:17:28 GMT

Hi Pradip,

I am not able to recreate the issue with sample data.

Re: Bold Text format for dim & Exp not working for null or zero values

RonaldDoes — Wed, 10 May 2017 07:24:53 GMT

Hi Pooja,

Do I understand you have a region "Total" in your data model?

Would it be practical to just use the partial sums in the chart? See below example.

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 07:34:11 GMT

Hi Ronald,

You are right, i have the 'Total' region in my data model. I cant use the partial sum property, because I have 5 regions in my data model, but i want to show only 2, the third one is the sum() of the 2 above, which is as it is in the source file itself.

Re: Bold Text format for dim & Exp not working for null or zero values

Anil_Babu_Samineni — Wed, 10 May 2017 07:36:10 GMT

Hello Pooja,

1) Does this Total Value under Region Field?

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 07:38:00 GMT

Yea Babu. Attaching the sample qvw.

This model is very similar to what I have in my actual requirement

Re: Bold Text format for dim & Exp not working for null or zero values

RonaldDoes — Wed, 10 May 2017 07:41:54 GMT

Hi Pooja,

The zeroes seem perfectly bold to me.

To illustrate, I've used the same expression to use a yellow color for the background.

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 07:48:16 GMT

Hi Ronald,

Like i mentioned, i am not able to recreate the scenario with sample data.

let me put a screenshot of my actual table.

If you see, the the Value 'Gross $$$' is the the one for which i need '<B>', and it is showing correct where there is value in the 'Misc Others' category. In the last line, the value for Misc Others is 0, and so the the 'Gross $$$' is in normal text.

Re: Bold Text format for dim & Exp not working for null or zero values

RonaldDoes — Wed, 10 May 2017 08:03:27 GMT

If in your example I alter the values to show 0 for US, it works as well, so there must me more differences between your problem qvw and the example.

Can you scramble/reduce your original qvw and share that perhaps?

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 08:57:44 GMT

Hi Ronald,

Its an application on my client machine. n i do not have access to copy it to any different environment

Re: Bold Text format for dim & Exp not working for null or zero values

Anil_Babu_Samineni — Wed, 10 May 2017 10:15:03 GMT

In fact, Your information is not good enough because as per your Data set it's working good. So finally, I would ask you to create sample data which is same where not working. Si that we can look the same

Re: Bold Text format for dim & Exp not working for null or zero values

poojask123 — Wed, 10 May 2017 10:43:55 GMT

Thanks Ronald. I decided to go by your suggestion to achieve what I am trying. Restricted the dimension values using match() and named the total column as "Gross $$$"