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.
vlakeshr
Contributor

Copy same formula for different sheets in Qlikview Doc.

How can use one formula for different 10 or 15 sheets, what is shortcuts?

5 Replies

Re: Copy same formula for different sheets in Qlikview Doc.

You may need to copy entire object and pasting the object into sheet is one option and another one may be create variable for that formula and use the same variable in next sheets..

Life is so rich, and we need to respect to the life !!!
prashantsanchet
Contributor

Re: Copy same formula for different sheets in Qlikview Doc.

You can try to create a variable and try to use variable

Re: Copy same formula for different sheets in Qlikview Doc.

Indeed, assign your expression to a variable, and expand the variable content in the Expression field using $-sign substitution like:

=$(vLYTDTurnoverUSD)

If you define a proper naming convention for those variables, it will become very clear what kind of expression is actually being used here. For example, the one used above means "Turnover in USD for Last-Year-To-Date".

Variables can be defined in Settings->Variable overview, but the best place to do this is in your load script. Or in an external file (text, Excel, xml, whatever) if you want to make your documents configurable from a central place.

vlakeshr
Contributor

Re: Copy same formula for different sheets in Qlikview Doc.

In one sheet , graph using same formula and second sheet straight table using same formula and in 3rd sheet new object using same formula and continue to sheet no. 15. This question was asked in interview and I suggest the same ans as by using variable / trigger but it is one more shortcut...that /I don't know.

vlakeshr
Contributor

Re: Copy same formula for different sheets in Qlikview Doc.

In one sheet , graph using same formula and second sheet straight table using same formula and in 3rd sheet new object using same formula and continue to sheet no. 15. This question was asked in interview and I suggest the same ans as by using variable / trigger but it is one more shortcut...that /I don't know.

Community Browser