Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached is the QVW for threshold problem i am currently facing.
I have:
User
date
Usage
I have create 3 input fields where user can provide threshold for Year, Month, day threshold.
I want to create a
Pivot table => that shows 3 columns. total usage by year, by month, by day. Color of the total will be either red or green based on their above input threshold.
Chart => that shows the same thing pivot table shows.
See attached example.
amazing thanks. How can you show chart with same value in green & red based on selection and non selection.
Using Gysbert's example add another "
if(GetSelectedCount(day)=0 and GetSelectedCount(month)=0 and GetSelectedCount(year)=0,if(sum(usage)>vdailythreshold,green(),red())
Note that the day, month, year now have "= 0". You will have to determine what criterial makes the bars green or red like in the orginal expression with the variable.
hth,
Stephen
Thanks I figured that one out.
Now if I had to show only those records that exceeds certain criteria. for example show records where monthly acceds certain number.
Your solution works as long as only 1 year, 1 month or 1 day is selected. Once user selected multiple months or days then the filters dont work.