Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a requirement:
- display total no of records - i assume is count(record_ID) ?
- display records that have made changes of the total of number records?
I have attached a sample qvw with inline data.
Please help guys.
Rgds,
Jim
This will give you a comma separated list of Record_ID which changed
=Concat(DISTINCT {<Record_ID = {"=Len(Trim(Only(Rating))) = 0"}>}Record_ID, ', ')
wow.... Sunny! thanks!!! all works!
I have a question, Sunny.
I created a filter called - rating, so it has 10.20,30. so when i select 20. it wont show me any result....
why is it so?
Rgds
Jim
The way the expression is structured, it gave you that result. May be try this:
=Concat(DISTINCT {<Record_ID = {"=Len(Trim(Only({<Rating, Record_ID = P(Record_ID)>}Rating))) = 0"}>}Record_ID)
Sunny Bro, for the Year...is it logical if i allow user to select filter Year?
Is it logical? I guess it would depend on user needs, right? I am not sure what exactly are you looking for?
for instance, user access the dashboard, user clicks on year 2016 to see what record_id's rating has changed.
Sure, that seems logical.
but i cant see it from here. is it bcos the record_id's has no changes in 2016?