topic Re: Reduce data after Binary load in QlikView

Reduce data after Binary load

Sat, 26 Nov 2016 06:10:56 GMT

hi Experts ,

I have a global QVW (All Countries data) , and wanted to create a dashboard for a particular Country.

I am using Binary load from that but want to restrict my dashboard for only One country.

We have an option of reducing the data by Reduce data -> Keep Possible value (manually).

Is there any way to do this at script level or with Publisher (I cannot use macro either).

Regards,

Abhishek

Re: Reduce data after Binary load

tresB — Sat, 26 Nov 2016 06:59:06 GMT

Yes both are possible. In the script you simply use WHERE clause to reduce the data. Publisher REDUCTION procedure can do exactly what you want.

Re: Reduce data after Binary load

Anonymous — Sat, 26 Nov 2016 07:00:00 GMT

Hi,

Here you have a...different countries of data,

you can filter the data at script level like following.....

then you can create separate dashboards for each and every country

suppose,

your original data like this...

you can filter your countries data in this way..

Re: Reduce data after Binary load

Anonymous — Sat, 26 Nov 2016 07:04:54 GMT

In script level you can filter the data...by using where clause

and in where clause...we can also use some functions like...match,mixmatch...etc., to filter the data

Re: Reduce data after Binary load

Sat, 26 Nov 2016 08:12:16 GMT

hi All ,

I wanted to check on restriction or post load data reduce after Binary load

My script is like

Binary c\User\Qlik\Global.QVW ;

This Global QVW has many tables linked with each other .

and I wanted to reduce data as per only one country.

Similar thing can be done with file -> Reduce data -> Keep Possible values .

I need similar thing in the script or via publisher.

Re: Reduce data after Binary load

Anonymous — Sat, 26 Nov 2016 11:35:20 GMT

I hope this will help you.,

after getting the data from binary load..

you want to display each country data in separate sheets right,

You can do like this,

in the sheet properties you can apply a 'trigger' . A trigger is an 'action' that is applied on a specific event like 'activate sheet'.

You can add an action to do a 'select in field' on the field you can pass your field name country and in string value..you can give our particular country name like ='India'

If you don't want users playing with the selection you can add a 2nd action to the trigger to 'lock field'.

If you do this on every sheet,(you can reduce data in every sheet)

Trigger on each sheet

1. Select in Field (country)

2. Lock Field (country)