Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have implemented Dynamic reports, and for selection of Measures I am loading fields from an excel sheet.
Now my question is can we load concatenated variable with column values in excel sheet. Ex
%Measures | %Measures_Flag |
Units Growth vs 3 Last Month | 9 |
Units Sold Last Month | 10 |
Units Sold Last 2 Month | 11 |
Units Sold Last 3 Month | 12 |
In above table I want 'Units Sold Last Month' as 'Units Sold '& $(vPreviousMonth) &' Month', thus it shows as 'Units Sold Jan Month '.
I know we can do this with if condition in load, but as we have multiple Measures thus we will end up with multiple conditions.
Regards,
Navdeep
Any help is really appreciated.
Hi
Please find the below approach.
Step1: Modify your script as below
SET HIDEPREFIX='%';
LOAD * Inline [
%Measures,%Measures_Flag
Units Growth vs 3 Last Month, 9
Units Sold Last Month, 10
Units Sold Last 2 Month, 11
Units Sold Last 3 Month, 12 ];
LOAD * Inline [
ID, Quantity
1,100
2,200
3,300 ];
Step2:
Create Chart (Straight Table) - ID as dimension and expression as Sum(Quantity) and now check Conditional and specify the expression as below
=SubStringCount(Concat(%Measures_Flag,'|'),10)
Step3: In chart properties of general tab, specify as
=GetSelectedCount(%Measures_Flag) > 0
Step4:
Now get %Measures Flag to the presentation layer and select 10, you can see the graph populated