Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have two Dimension fields like
Task Name and SubTask Name
for that i am writing like below
Wildmatch (GetFieldSelections([%Field_name],',',200) , '*Task Name*') and GetSelectedCount([%Field_name]) >0
Wildmatch (GetFieldSelections([%Field_name],',',200) , '*SubTask Name*') and GetSelectedCount([%Field_name]) >0
i am doing in char conditional properties
but when i select subtask name i am getting both Task and SubTask Name which it should not be.
Try this
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|'), '|Task/Task Name|') = 1 and GetSelectedCount([%Field_name]) > 0
and
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|'), '|SubTask/SubTask Name|') = 1 and GetSelectedCount([%Field_name]) > 0
Try this
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|"), '|Task Name|') = 1 and GetSelectedCount([%Field_name]) > 0
and
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|"), '|SubTask Name|') = 1 and GetSelectedCount([%Field_name]) > 0
Hi Sunny,
no, it shows some syntax error.
Below is what i am doing my report , i have my export fields . so when i select task name it should give me only Task name and when i select subtask name it should give me only subtask name. but when i select subtask Name it is giving Task name as well. below is the snapshot.
i wrote in below chart Properties in enable condition as show in below snapshot
Wildmatch (GetFieldSelections([%Field_name],',',200) , '*SubTask Name*') and GetSelectedCount([%Field_name]) >0
I understand the issue, but did you try this condition instead of yours (for SubTask Name dimension)?
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|"), '|SubTask Name|') = 1
and
GetSelectedCount([%Field_name]) > 0
Hi Sunny,
May be some thing is missing.
Try this
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|'), '|SubTask Name|') = 1 and GetSelectedCount([%Field_name]) > 0
Accidentally, added a double quote instead of a single quote
Would you be able to share a sample of your app to check this out?
HI,
Please find the attached file.
Best Regards,
Try this
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|'), '|Task/Task Name|') = 1 and GetSelectedCount([%Field_name]) > 0
and
SubStringCount(Concat(DISTINCT '|' & [%Field_name] & '|'), '|SubTask/SubTask Name|') = 1 and GetSelectedCount([%Field_name]) > 0