Weekly SNAPSHOT of STRAIGHT Table

[#1]

Hi all,

is there a possiblity in QlikView storing values out of a straight table once a week?

SAP does not deliver historical values about this - therefore we loose the possibility showing a development of the figures..

These values per category should be saved..

Thank you a lot for your ideas!

Regards

Barbara

[p_verkooijen]

Hi Barbara,

For a automated export you'll need Qlik NPrinting or a similar tool. See https://market.qlik.com

You also could store a set of data from the load script into a QVD, create historical values by adding a date in the filename..

[sunny_talwar]

Although I would discourage to use it, but you can use a post reload trigger to run a macro which would store the content of your straight table into a qvd. I don't have the exact syntax, but if this is something you want to explore, I might be able to look around for it.

Best,

Sunny

[jyothish8807]

Hi Barbara,

You can store the historic data in to QVD.

Try to create a weekstart date from the reloadtime() as identifier and keep concatenating the data in script.

Other wise you can use macro's as suggested by Sunny and Paul.

Regards

KC

[beck_bakytbek]

Hi Barbara,

you can try this code, with help of this code, you can create a snopshot / Image of your tables:

public function ExportImage

ActiveDocument.GetApplication.WaitForIdle

ActiveDocument.GetSheetByID("yourTab").Activate


vFolder = ActiveDocument.GetVariable("vExportFolder").GetContent().String

set obj = ActiveDocument.GetSheetByID("yourTab")

ActiveDocument.GetApplication.WaitForIdle

fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

set obj = ActiveDocument.GetSheetObject("IDofYourObject")

ActiveDocument.GetApplication.WaitForIdle

fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName
end function

let me know, when you solve your issue

i hope that helps

beck

[p_verkooijen]

Hi Beck,

Since load * from ..png doesn't work , saving into a png doesn't make it usable solution for saving historical data.

[beck_bakytbek]

Hi Paul,

i thought, this type of my solution can help to solve this issue or to find more better solution, i create my snapshots and save in Folder, i think it depends on your Business Environment.

But thanks a lot for your Feedback

beck

[#8]

Hi Beck,

thank you for your idea - I actually do "save" pdfs, because each Monday a PDF is getting distributed to certain persons per Mail. So saving pictures is unfortunately not helping in this case..

thanks,

Barbara

[#9]

Hi Paul,

I was afraid having this possibility only with add-on tools.

We do get NPrinting by August - so then we might have a solution then..

Unfortunately the data is not generated within the script - the expressions are on the surface...

thanks,

Barbara

[p_verkooijen]

Hi Beck,

You're almost there

Instead of export to png

fileName = "ExportScreen_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".png"

ActiveDocument.GetApplication.WaitForIdle

obj.ExportBitmapToFile vFolder & fileName

You could also export to QVD

fileName = "ExportData_" & replace(replace(replace(date() & "_" & time(), "/", ""), ".", ""), ":", "") & ".qvd"

ActiveDocument.GetApplication.WaitForIdle

obj.Export vFolder & fileName, 4