Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
babakpirooz
New Contributor

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

Tags (2)
1 Solution

Accepted Solutions

Re: How to Implement Dynamically Expression From Load Inline

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

1 Reply

Re: How to Implement Dynamically Expression From Load Inline

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

Community Browser