Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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