Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Implement Dynamically Expression From Load Inline

Hello Dear

i want Implement chart Dynamically Expression   From Script

In the event that user select formula-title list Box ,show Related expression from formula-title and set on chart

01.png

02.png

1 Solution

Accepted Solutions
MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_236413_Pic1.JPG

QlikCommunity_Thread_236413_Pic2.JPG

QlikCommunity_Thread_236413_Pic3.JPG

QlikCommunity_Thread_236413_Pic4.JPG

QlikCommunity_Thread_236413_Pic5.JPG

GenreValue:

LOAD 'Genre'&Ceil(Rand()*10) as Genre,

    Ceil(Rand()*100) as interest,

    'Gender'&Ceil(Rand()*2) as Gender

AutoGenerate 30;

Expression:

LOAD RecNo() as ID, * INLINE [

    FormulaTitle, Formula

    Interest Rate, Sum(interest)

    Relative to the total amount of interest, "Num(Sum(interest)/Sum(Total interest),'##0.0%')"

];

see also:

The Magic of Variables

The Magic of Dollar Expansions

The Little Equals Sign

hope this helps

regards

Marco

View solution in original post

1 Reply
MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_236413_Pic1.JPG

QlikCommunity_Thread_236413_Pic2.JPG

QlikCommunity_Thread_236413_Pic3.JPG

QlikCommunity_Thread_236413_Pic4.JPG

QlikCommunity_Thread_236413_Pic5.JPG

GenreValue:

LOAD 'Genre'&Ceil(Rand()*10) as Genre,

    Ceil(Rand()*100) as interest,

    'Gender'&Ceil(Rand()*2) as Gender

AutoGenerate 30;

Expression:

LOAD RecNo() as ID, * INLINE [

    FormulaTitle, Formula

    Interest Rate, Sum(interest)

    Relative to the total amount of interest, "Num(Sum(interest)/Sum(Total interest),'##0.0%')"

];

see also:

The Magic of Variables

The Magic of Dollar Expansions

The Little Equals Sign

hope this helps

regards

Marco