topic Re: Macro for export to excel for different values based on chart field in QlikView

Macro for export to excel for different values based on chart field

Thu, 05 Dec 2013 16:27:22 GMT

Hi all,

I need your help. I want to export the report to excel according to the values in the field of the chart.

Please help me

Re: Macro for export to excel for different values based on chart field

Gysbert_Wassenaar — Thu, 05 Dec 2013 16:49:15 GMT

Is this the kind of thing you're looking for: Loop Charts and Field Values - Excel Export Macro

Re: Macro for export to excel for different values based on chart field

Fri, 06 Dec 2013 06:09:46 GMT

Thanks for your answer

But i dont want the excel for each values of the field Month. As in CH02, only Apr and Jan is displayed so i also want excels for only these two values

Waiting for an urgent reply

Re: Macro for export to excel for different values based on chart field

Fri, 06 Dec 2013 06:40:07 GMT

Thanks for your answer

But i dont want the excel for each values of the field Month. As in CH02, only Apr and Jan is displayed so i also want excels for only these two values

Waiting for an urgent reply

Re: Macro for export to excel for different values based on chart field

Gysbert_Wassenaar — Fri, 06 Dec 2013 15:27:40 GMT

Ok, so you didn't actually check to see what it does. It uses the getpossiblevalues function so it does not use every field value, only those that are either selected directly or possible as a result of selections in other fields.