topic Re: Flagging multiple lines to extract reports. in QlikView

Flagging multiple lines to extract reports.

Wed, 27 Nov 2013 08:43:19 GMT

Hi all,

I've tried searching but haven't had much luck - i might be on a fruitless quest!

What I'm looking to do is in one chart (straight table) have some sort of a check box where I can select certain lines without filtering the data. These 'checks' need to stay in place while selections change then when done be able to export these selections somehow, maybe as a report.

If i haven't been clear and need to explain further please let me know - as the above makes sense to me but might not to others!

The reason is the data shown in the dashboard in question has links to invoices that are assigned to specific cost centres, but some of these invoices need to have the total cost split to different cost centres depending on what they are.

I know this could be done manually (writing down the invoice number as you go) but it would be fantastic if I could build it into the system.

Hope someone can help!

David.

Re: Flagging multiple lines to extract reports.

Nicole-Smith — Wed, 27 Nov 2013 15:04:37 GMT

I think you would need to write an extension object for this.

Re: Flagging multiple lines to extract reports.

Fri, 29 Nov 2013 12:51:44 GMT

Thanks Nicole, I thought that might be the case.

I'm confident enough to give it a go but am unsure as to where to start - any advice on a starting point would be more than welcome.

Thanks,
David

Re: Re: Flagging multiple lines to extract reports.

Anonymous — Fri, 29 Nov 2013 13:15:27 GMT

David

How about you:

Create an Alternate State called say InvoiceSelect
Create a List Box against this Alternate State InvoiceSelect
- Maybe change its Selection Style Override to Windows CheckBoxes
- This will be used to select your required invoices

Create an Object for your data
Filter on your Alternate State InvoiceSelect
But in your expression also filter against the default $ State to reflect other selections
- You'll probably need some cunning Set Analysis here..............

Best Regards, Bill

Re: Flagging multiple lines to extract reports.

Nicole-Smith — Mon, 02 Dec 2013 13:57:10 GMT

If you're going to go the extension route:

Stefan Walther has an (in progress) tutorial at Extensions
Barry Harmsen has some good information at QlikView Extension tutorials, documentation and examples » The Qlik Fix! The Qlik Fix!
And of course, there is the QlikCommunity forum at Extensions