Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hello,
To simplify further your example and to avoid writing new nested if statements each time, you can follow the steps below:
1. Create a new load for the severities:
2. Now you can modify the charts as follows:
This method, doesn't require nested if statements, because:
- Num#(Replace('Severity1', 'Severity', '')) // Will convert Severity1, Severity2, Severity3 etc. to 1, 2, 3 etc.
- Pick(...) // Will return the needed expression based on the return from Nujm#(...)
- This means that if the Severity is 1, it will convert Severity1 to 1 and thus Min({<Description={'$(v23007)'}>}Min4) expression will be evaluated.
With this method, in case you need to add new severity, you just add it in the load script and then update the charts with additional line for the expression. Without needing to do if statements.
Your charts when Severity1 is selected:
My charts when Severity1 is selected:
As you can see they are the same so it is working!
I hope that this information is helpful.
Hello @nvijay5757,
Perhaps the following use case scenario might help you:
1. You can load the ProgramNumber and ProgramCode as a value (Either with Load Inline statement or EXCEL file etc.):
2. After that I have loaded a demo dataset:
3. Now I want to create a measure that will show the ProgramCode. Instead of having multiple nested if statements as you have mentioned, I have used the following expression: SubField(Concat(ProgramCode, ','), ',', Program)
This expression will:
- Concat(ProgramCode, ',') // Concatenate all the values in ProgramCode and will add a comma between them
- SubField(...) // Will split the concatenated field by comma and Program will indicate which part of the split value you want to get
4. Outcome is:
NOTE: Since we have ProgramNumber associated with ProgramCode, you can also use this in other use case scenarios.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Hello,
To simplify further your example and to avoid writing new nested if statements each time, you can follow the steps below:
1. Create a new load for the severities:
2. Now you can modify the charts as follows:
This method, doesn't require nested if statements, because:
- Num#(Replace('Severity1', 'Severity', '')) // Will convert Severity1, Severity2, Severity3 etc. to 1, 2, 3 etc.
- Pick(...) // Will return the needed expression based on the return from Nujm#(...)
- This means that if the Severity is 1, it will convert Severity1 to 1 and thus Min({<Description={'$(v23007)'}>}Min4) expression will be evaluated.
With this method, in case you need to add new severity, you just add it in the load script and then update the charts with additional line for the expression. Without needing to do if statements.
Your charts when Severity1 is selected:
My charts when Severity1 is selected:
As you can see they are the same so it is working!
I hope that this information is helpful.
