Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
gireesh1216
Creator II
Creator II

Export data with multipul filters

Hello Team,

Below is the raw data and need to export the data to excel in one shot based on below selections.

1) Select Date='1/3/2020' and Rep Filter='Y' in list box (Will get two rows i.e ID 3,5 )

2)Select Date='1/3/2020',Rep Filter='N' and Report ='C' in list box (Will get one row i.e ID 4)

We need to export above data to excel in one shot. As of now we are doing two times export and merging the point No 1 and 2.

DateReportRep FilterID
1/1/2020AY1
1/2/2020BN2
1/3/2020CY3

1/3/2020

 

CN4
1/3/2020EY5

 

Results:

DateReportRep FilterID
1/3/2020CY3
1/3/2020CN4
1/3/2020EY5
1 Reply
Brett_Bleess
Support (Former)
Support (Former)

It would likely be most helpful if you attach the QVW file on this one, so folks can see the data model and chart with expressions etc. to try to come up with best approach for the solution.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.