Pivot table Hide Column

[meenakshi_m]

pivot table Hide Column

Hello

I have created a Measure by using this sum(marks)-before(sum(marks)).

Now how can i hide first column where values are showing as "-"

Please see the attached image for more info.

[meenakshi_m]

Hello

I have created a Measure by using this sum(marks)-before(sum(marks)).

Now how can i hide first column where values are showing as "-"

Please see the attached image for more info.

[Anil_Babu_Samineni]

Please share the sample application to test as workaround?

[meenakshi_m]

Hi

Appreciate your help .Please find attached.so the column which has null needs to be hidden.

[Anil_Babu_Samineni]

Afaik, So far my knowledge that's not possible. But let's see If @marcus_sommer can advice workaround.

[marcus_sommer · Accepted solution]

Within the classical Qlik logic it's not possible because there exists results for the dimension-value of 1991. If there is any it will be displayed for each measure.

An alternatively would be to remove the year as dimension and creating for each wanted combination of the measure + the year an own expression. In this case you couldn't really use your applied logic with the interrecord-function else you will need to specify your conditions per set analysis within the expressions, maybe with something like this:

sum({< Year = {"$(=max(year)-1)"}>} marks)
sum({< Year = {"$(=max(year))"}>} marks)
sum({< Year = {"$(=max(year))"}>} marks) - sum({< Year = {"$(=max(year)-1)"}>} marks)

- Marcus

[meenakshi_m]

yes perfect .This has worked for me.Thank you

[Happy_Qlicking]

Hi all, I have the same problem. But as I am using a Measure in my pivot, I cannot use set expression to it or modify it. So what is the solution?