Pivot Table Column Issue

[waqasshah]

Hi Guys,

I need you help. Actually I am trying to hide the column during calculation if there is  zero or Null value. Please review the attached qvw file.

First thing is I have calculated the total number of jobs done in these financial years and then the difference between the jobs in these financial years.

As you have noticed in Difference tab financial year 2016/2017 is zero because we do not have data for previous financial years like 2014/2015 or 2015/2016. I basically want to hide the column "2016/2017" because it is showing zero values.  can someone please help ?

[waqasshah]

Thanks again. it means any value if it is NULL  or zero  in that complete column  the column will  be hide..

Apologise for asking so many question. I have changed the qlikview file by adding another column its fine.

When I am trying to implement the logic on live the column displayed with financial year (2016/2017)  heading ....

[waqasshah]

So far the conclusion is first we need to add ISLAND table and identify  number of columns we want to display and then  specify in dimension the column names and then in expression we need to use the same number column of columns and always make sure Suppress zero value option is checked.. correct me if I am wrong

[waqasshah]

Sunny I got the answer. Actually its a versioning issue. Your solution works on latest version but no on old version. my qlikview version is Version 11.20 SR 13.

Thanks again for your help. Really appreciated.

Kind Regards

Waqas Shah

[sunny_talwar]

I think it might still work on a different SR of version 11.20. Have you tried to upgrade or downgrade from SR13? Also, please close the thread if you have got what you wanted.

Best,

Sunny

[waqasshah]

I will try upgrade.. How to close the thread ?

[sunny_talwar]

Check here

Qlik Community Tip: Marking Replies as Correct or Helpful