Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reduce data after Binary load

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

5 Replies
tresesco
MVP
MVP

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.

Anonymous
Not applicable
Author

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...

,,.dib

you can filter your countries data  in this way..@@@.png

Anonymous
Not applicable
Author

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

Not applicable
Author

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.

Anonymous
Not applicable
Author

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)