This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
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.
Any help is really appreciated.
Please find the below approach.
Step1: Modify your script as below
LOAD * Inline [
Units Growth vs 3 Last Month, 9
Units Sold Last Month, 10
Units Sold Last 2 Month, 11
Units Sold Last 3 Month, 12 ];
Create Chart (Straight Table) - ID as dimension and expression as Sum(Quantity) and now check Conditional and specify the expression as below
Step3: In chart properties of general tab, specify as
=GetSelectedCount(%Measures_Flag) > 0
Now get %Measures Flag to the presentation layer and select 10, you can see the graph populated