Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to show a chart which only shows values for Fridays when a date is selected.
I have BUSINESS_DATE as the dimension and the following as the expression
sum(if (weekday (BUSINESS_DATE)=5) & BUSINESS_DATE <= DATE(MAX(BUSINESS_DATE), CREDIT_BALANCE))
It only shopws data for the date selected.
Why you don't create a list box with an expression : = weekday (BUSINESS_DATE) and the chart you want to display, then just select the day you want to analysis.
JJ
Are you also making the selection on BUSINESS_DATE or is it another field?
You need to use Set Analysis to ignore the selection otherwise QlikView will only show records related to the selection. Ignoring all selections with Set Analysis uses {1}.
sum({1}if (weekday (BUSINESS_DATE)=5) and
BUSINESS_DATE <= DATE(MAX(BUSINESS_DATE), CREDIT_BALANCE))
When there is no date selection, do you want to show all dates?
Also, if you want to respect some selections and only ignore the selection on the date selected, then it is a little trickier.
Thanks for this. There is a calendar where the user selects a single day. I would then like to show all Fridays up to an including the date selected.
If no date is slected, then I would liek to use the max of Date as the date.