topic Value in Chart - conditional in QlikView

Value in Chart - conditional

QFanatic — Sat, 16 Nov 2024 00:29:45 GMT

hi guys

PFA

On the chart - if a Weekday falls on a Sunday, I dont want to display 'N/A' - I want to display the word 'Sunday' - is that possible? Since I dont have WEEKDAY as a dimension in the chart - what would the expression look like?

If not - I can highlight the cell in red for instance.

Thank you

Re: Value in Chart - conditional

rubenmarin — Fri, 12 Jun 2020 17:38:34 GMT

Hi, in example for 1st column you can add:

=If(Only({<PERIODID = {$(=Max(PERIODID)-1)}>} WEEKDAY)='Sun', 'Sunday', [Expression_as_it_is_now])

Re: Value in Chart - conditional

QFanatic — Fri, 12 Jun 2020 19:28:54 GMT

Thank you