Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Please share the sample application to test as workaround?
Hi
Appreciate your help .Please find attached.so the column which has null needs to be hidden.
Afaik, So far my knowledge that's not possible. But let's see If @marcus_sommer can advice workaround.
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
yes perfect .This has worked for me.Thank you
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?
Please create a another thread for this.