Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic reports visible Measures field

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  Month9
Units Sold  Last Month10
Units Sold Last 2 Month11
Units Sold Last 3 Month12

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

2 Replies
Not applicable
Author

Any help is really appreciated.

satishkurra
Specialist II
Specialist II

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