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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-07-18 02:38 PM

How to store expression in Variables in Excel Sheet

I am using same expression in many charts, I think it will be more efficeint if I create a variable for each expression and call them from excel sheet. Can anyone help me start on it by advices or pointing to a thread??

2,138 Views
0 Likes
5 Replies
sunny_talwar
MVP
MVP
‎2015-07-18 02:50 PM

Take a look at the attached sample. Hopefully this will help.

Best,

Sunny

Preview file
9 KB
Community_173124.qvw
1,538 Views
Anonymous
Not applicable
‎2015-07-18 02:55 PM
Author

Thank you Sunny and Massimo!

1,538 Views
0 Likes
Anonymous
Not applicable
‎2015-09-23 07:09 PM
Author

In response to sunny_talwar

Sunny,

can you pls explain i=0 and next in your script.

Many Thanks.

imageFile.png

1,538 Views
0 Likes
sunny_talwar
MVP
MVP
‎2015-09-23 11:10 PM

In response to Anonymous

'i' is a For loop initiation variable and next is used to increment 'i'. For more details check out this wikipedia link: For loop - Wikipedia, the free encyclopedia

1,538 Views
0 Likes