Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Don't show empty colum in pivot table

Hello,

I have a simple pivot table which contains :

- 2 dimensions : Classe and Year

- 2 expressions : CA and Var

Var = (CA(Year)-CA(Year-1)) / CA(Year-1)

As the minimum Year in my Period table is 2012, there is no Var for this year as it's shown in the printscreen below (Table 1)

I want to hide only the column without data and I want to show my table like Table 2 in the printscreen.

Forum.png

I tried many expressions in the conditional show of the expression but didn't find a solution.

Is it possible ?

Thanks in advance

6 Replies
manish_madan
Creator
Creator

Hi,

Is it possible to hide expression in pivot table?

Check if it helps.

Thanks

Manish

Not applicable
Author

Try to use a condition in the expression.

manish_madan
Creator
Creator

Hi Ghassen,

do you have any field which is always one selected?

Thanks

Not applicable
Author

While giving the expression for Var

there is a button in the expression tab which says Conditional

you can try giving the condition of year>2012

Not applicable
Author

Thank you all for your answers.

I tried many expressions in the conditional expression but it works for all the years, not only for 2012.

I think it's impossible to hide an expression for only one value of the dimension.

Not applicable
Author

give an if statement in the expression saying

if(year>2012,Var)

it will work for sure