Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Macro

Hello

HI GUys Iam using the macro to export the straight table into qlikview

Actaully i want to  export the values only for SOuth Region from the list box

How do we write the macro for this ?

As of now iam getting the data into excel for all the region  but i want to export the values from straight table only for south region .

Can some one  help me please

Thanks in Advance

4 Replies
Not applicable

Hi John,

Please find the attached qvw, and follow the 2 steps mentioned in it.

Thats the solution to what you need.

If somethings missing, plz write back in detailed words, supported by images, it becomes easy to understand with images.

Thanks & Regards

Swapneel

smilingjohn
Specialist
Specialist
Author

HI Swapneel

Thanks for your reply

Ok now i can explain you as u have the list box for region , there in my dashbaord i have under Region

South

East

West

North

And also i have the straight table which has many values also

Now iam exporting the values to excel from the staright table , and simultaneously i want to export the values from straight table to different excel sheet   pertaining only to south withouth any selection

how do i  write the code for this

i hope u understaood

Not applicable

Hi John,

Plz check out the file again, I have modified it to suit your needs.

Plz check the table structure by "Ctrl + T" in Qlikview.

And then select the export button.

Thanks & Regards

Swapneel

Not applicable

Hi John,

If your query has been answered, plz mark it as answered by selecting appropriate answer as correct answer.

So that the discussion gets closed on the community.

Thanks,

With Regards

Swapneel