Export data with multipul filters

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Date	Report	Rep Filter	ID
1/1/2020	A	Y	1
1/2/2020	B	N	2
1/3/2020	C	Y	3
1/3/2020	C	N	4
1/3/2020	E	Y	5

Results:

Date	Report	Rep Filter	ID
1/3/2020	C	Y	3
1/3/2020	C	N	4
1/3/2020	E	Y	5

Re: Export data with multipul filters

Brett_Bleess — Tue, 08 Sep 2020 15:52:22 GMT

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

topic Export data with multipul filters in QlikView

Export data with multipul filters

Re: Export data with multipul filters