Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
And I included datasource and qlik sense app in case reloading is necessary
Thanks a lot !!!!!!
Unfortunately, you can't selectively hide individual measure columns depending on which dimension value they're under.
Thanks for your reply