Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Table Top label missing when i select month=1

Hi All

I have a table 1 , which is top row label is working fine in the past.The script as below :-

='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-2)'}>}month), Num(Month(Today())))))& ' ' & ' ' & (max(year)-1) & ' ' &ColumnDim51& ' '

Now i add new raw data , i notice that when i select month=1 the label dis-appear. Hope some one can help me.

Paul Yeo

1 Solution

Accepted Solutions
settu_periasamy

Hi,

Can you check this part?

2018 data is not there. that's why it is giving null value.

2020-02-18_10h32_09.png

You can try like Max({1}year)-1

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

Hi All

Enclosed my QVW

settu_periasamy

Hi,

Can you check this part?

2018 data is not there. that's why it is giving null value.

2020-02-18_10h32_09.png

You can try like Max({1}year)-1

View solution in original post

paulyeo11
Master
Master
Author

Hi Sir

You are very sharp. So there is no way i can force it to display when i don't have value right ?

In that case i think it is okay , as one year later it will be solve by itself.

Paul