topic Re: ColumnNo() Function issue in QlikView

ColumnNo() Function issue

krishnacbe — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am using below expression in a Pivot Table in Expression -> Background color. It is working fine in 11.2.

We recently migrated to 12.10, the color for the total column is apply here and there not to ColumNo()=0

if(RowNo()=0 or IsNull(RowNo()) or ColumnNo()=0 or IsNull(ColumnNo()),vColor_RGB_16,vColor_RGB_15))

Expectation is to Color Total Columns (Row Wise total & Column Wise Total) with Dark Grey color.

Thanks in Advance.

Regards

Krishnapriya

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 13:36:13 GMT

May be use Dimensionality() instead of ColumnNo() and RowNo()

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 13:37:35 GMT

How to use - Dimensionality()

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

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 13:39:28 GMT

Thanks Sunny, will try Dimensionality().

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 13:49:20 GMT

Do you think, Dimensionality() will help in applying colors to Total Column (Partial Sums)

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 13:49:53 GMT

I think it should... I don't see a reason why it won't

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 13:54:05 GMT

Dimensionality() or secondaryDimensionality() functions are used to Color the actual data part and not the Total.

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 13:55:53 GMT

This is based on testing or just what you think?

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 14:01:11 GMT

I have tested both the functions, it applies color to entire dimensions and Total column

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 14:03:52 GMT

Would you be able to share a sample where this isn't working?

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 14:09:09 GMT

let me create a mockup data and share it

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 14:41:48 GMT

Below Expression Solved the issue.

if(Dimensionality()=0 or SecondaryDimensionality()=0,vColor_RGB_16,vColor_RGB_15))

Thanks a lot Sunny for your help

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 14:45:20 GMT

Awesome!! I told you it is going to work

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 14:50:09 GMT

Yeah, I tried then separately it didn't work. Both in same expression worked perfectly.

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 14:52:19 GMT

Well you didn't really share which total were you trying to color, so I can only give you a general direction and nothing specific. If you look for very specific help, I would suggest sharing more information then you did

Re: ColumnNo() Function issue

krishnacbe — Wed, 30 Aug 2017 14:55:07 GMT

While creating mockup data only I found the Solutions

Re: ColumnNo() Function issue

sunny_talwar — Wed, 30 Aug 2017 14:56:58 GMT

That's great, so next time you have an issue, start with creating a mockup and you might as well resolve your issue