topic Re: File Explorer in Qlikview in QlikView

File Explorer in Qlikview

Tue, 17 Mar 2015 10:26:32 GMT

Hi,

I would like to make a file explorer kind of application in Qlikview.

Which would, display the tables in the left pane, and also display the tabular data in right pane on selection of a particular table.

Plz find the file attached for the concept

Any thoughts ? How this can be achieved ?

Experts plz suggest & guide !

Thanks & Regards
Swapneel

Message was edited by: Swapneel Golapkar

Re: File Explorer in Qlikview

agni_gold — Tue, 17 Mar 2015 10:59:11 GMT

What you want ?

Is you want layout ?

Re: File Explorer in Qlikview

Tue, 17 Mar 2015 11:07:03 GMT

HI @Agnivesh Kumar

Plz find the attached file for the concept

Thanks,

With Regards,
Swapneel

Re: File Explorer in Qlikview

agni_gold — Tue, 17 Mar 2015 11:17:17 GMT

No attachment found

Re: File Explorer in Qlikview

cleitoncabral2 — Tue, 17 Mar 2015 11:22:49 GMT

you want to build this layout?

Re: File Explorer in Qlikview

Wed, 18 Mar 2015 04:39:45 GMT

Yes

Re: File Explorer in Qlikview

Wed, 18 Mar 2015 04:42:19 GMT

I have attached the file to my discussion. Plz find it in below link (Its an excel file, to show the concept)

File Explorer in Qlikview

Re: File Explorer in Qlikview

agni_gold — Wed, 18 Mar 2015 08:56:14 GMT

Hi Swapneel Golapkar,

Look into the attached file , you can go through like this . This is the one sheet , you can have multiple sheets like that .

Re: File Explorer in Qlikview

Wed, 18 Mar 2015 09:07:07 GMT

Thanks @ Agnivesh,

I think that would be of some use for me, the thing is i have many tables, of which displaying data is fine, but I dont know how will I be able to generalize the chart generation for all the tables.

Regards

Swapneel.

Re: File Explorer in Qlikview

agni_gold — Wed, 18 Mar 2015 09:55:47 GMT

Need to create the perfect data model in qlikview. After this you will only show the fields in listboxs which are required , and your charts are linked with these listboxes and the selection will associated with the data visualization .

Re: File Explorer in Qlikview

marcus_sommer — Wed, 18 Mar 2015 11:39:01 GMT

You could build such logic with the qlikview system-fields like $Table, $Field, $Fields ... which could be used in normal qlikview-objects. To start with this topic you could take an inbuilt qlikview object - New Object --> Data Structure or Structure Table.

To build dynamically objects based on selections on these system-fields is a little more complex and need something like: $(=$Field). See here for hints and to many examples: http://community.qlik.com/message/386575#386575

Another tip, try to build a logic which supported your goals behind this layout and not necessary the layout itself.

- Marcus

Re: File Explorer in Qlikview

Thu, 19 Mar 2015 03:52:45 GMT

Thanks Marcus Sommer & Agnivesh