topic Re: Export trigger qlikview in QlikView

Export trigger qlikview

Anonymous — Tue, 06 Mar 2018 04:44:28 GMT

I add export button from actions--add-External--export . i am done with this and also file export in folder but the problem is

when i select record from table e.g. i have tehse records

Head	Price	Month	Sub heads
Marketing	200	12-Jan-17	Mark1
Marketing	200	13-Feb-17	Mark2
Marketing	200	14-Feb-17	Mark3
Misc	1200	3-Jan-18	Mark4
Misc	1300	1-Jan-18	Mark5
Misc	1300	13-Jan-18	Mark6
Misc	1100	5-Mar-18	Mark7
Ins	1200	5-Mar-18	Mark8
Ins	1300	5-Mar-18	Mark9
Ins	1500	5-Mar-18	Mark10

so when i select Ins table shows only ins record and then when i try to click on export button this export only these last 3 records.. where as i want whole table on file what ever selection is made..

Re: Export trigger qlikview

ali_hijazi — Tue, 13 Mar 2018 08:35:33 GMT

add an alternate state (Settings->Document Properties->General->Alternate State

then right click on your table and assign it to that alternate state

in this way you are isolating the table from the current selection set of data

you can also make your table readonly so that no selection is made in the alternate state

N.B. you need to add current selection box and assign it to your alternate state to view any selection made in that state

Re: Export trigger qlikview

anagharao — Tue, 13 Mar 2018 09:48:33 GMT

Hey,

You could create an alternate state and add that to the Action on the button. This way the table would filter data but when extracting the information you would get all the records.