topic Re: Dynamic reports visible Measures field in QlikView

Dynamic reports visible Measures field

Mon, 09 Mar 2015 07:22:25 GMT

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

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

Mon, 09 Mar 2015 12:43:35 GMT

Any help is really appreciated.

satishkurra — Sun, 12 Apr 2015 07:28:15 GMT

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