topic Export formulas in excel in QlikView

Export formulas in excel

Wed, 07 May 2014 10:22:57 GMT

Big issue...qlikview formulas are those of the set analysis, is there a way to (and case how) "convert" and export formulas into excel?

i.e. I have a pivot chart into QLikview and there are expressions in it (which follow the set analysis rules, obviously). I was wondering in which was and how they can be exported into excel...I suppose they must first be "converted" into the excel syntax...is itpossible?

Is there another way to face it?

Re: Export formulas in excel

tresB — Wed, 07 May 2014 10:25:58 GMT

Settings->Expression Overview ->Export

Re: Export formulas in excel

ashfaq_haseeb — Wed, 07 May 2014 10:28:01 GMT

Hi,

Go to Setting --> Expression overview --> Click on Export Button.

All your expression will be exported to .tab file.

Please use Notepad++ to open this file.

Regards

ASHFAQ

Re: Export formulas in excel

Wed, 07 May 2014 10:33:10 GMT

i think we can export from the edit script tab gotofile >>>>>> export script from file>>>>

Re: Export formulas in excel

Wed, 07 May 2014 10:37:12 GMT

I think I haven't been clear enough...I want to export the all pivot chart that I have in excel and I want that when I click in a cell that has a formula, I want to visualize it...is it possible?

Re: Export formulas in excel

tresB — Wed, 07 May 2014 11:55:49 GMT

I am afraid that this is not possible.

Re: Export formulas in excel

Wed, 07 May 2014 12:01:10 GMT

tresesco I was think that too...just wanted to be sure..thank you for confirming it!