Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
GillBech
Contributor III
Contributor III

Hide measures in crosstable depending on dimensions

Hello everyone and thanks in advance

I created a sales/Objectives crosstable
I have objectives for all months, but as year is not finished, only actual sales for past (Year to date) and current months (current), therfore no figures for the future (Year to go)
For each month , I display Sales previous year, Objective, Actual Sales N, % Sales N /Objectives

My question is : how can I HIDE : Actual Sales N, % Sales N /Objectives if month is after current month
since the value will be 0 => useless

Here are 2 crosstables : one with month and the other with YTD/Current/YTG
Same requirement, based on mnth or YTG, 
GillBech_1-1691915280142.png

 

GillBech_0-1691915249715.png

 

 


And I included datasource and qlik sense app in case reloading is necessary

Thanks a lot !!!!!!

 

 

 

Labels (3)
2 Replies
Or
MVP
MVP

Unfortunately, you can't selectively hide individual measure columns depending on which dimension value they're under.

GillBech
Contributor III
Contributor III
Author

Thanks for your reply