Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
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