Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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..
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
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.
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)