topic Default value for expression in QlikView

Default value for expression

Wed, 06 Jan 2010 16:43:31 GMT

Hi All,

How can we default value for expression.( i.e when you open dashboard expression should show the customer value rather than sum of measure.

Here are the details:

1. We have one list box that contains regions values like US, UK, GER... and network

2. We have expressions called Customer visits (sum of Customer visits) , availability( avg of availability) ..ect

When you open the dashboard (qvw file) Customer visits showing Sum of visits for all regions US,UK,GER..and network .

However user wants to see only network values rather sum of all values.

Then if they select any region it should show the US values.

Thanks,

Raghav

Default value for expression

Wed, 06 Jan 2010 23:20:03 GMT

Hi Raghav,

When you refer network you mean the salesman network or salesman region?

If that's the case, one way to do it is through a data reduction by login. The immediate result is that each use only see their relevant data, that means their working region, customers, etc.

If that's not the case and you still want to filter your initial data to a certain rule you can do it defining the filters to be applied when the document or each sheet is open - (Settings - Document Properties - Document Event Triggers- OnOpen - Add Action - Add- Selection (in Selection Type) - Select in Field and then Define the filter and the value to be selected). The process is more or less the same if you want to specify diferent initial selection for each sheet.

If you don't want to shash the data by login and the filtering onOpen rules doesn't apply to your requirement it might be possible to do it through a macro that filters the data by user when the document is open but that's another story and I'm not the right person to help you out.

Cheers

Joao

Default value for expression

Thu, 07 Jan 2010 16:18:17 GMT

Hi Joao

Thanks for your reply.

Normal 0 false false false MicrosoftInternetExplorer4

Your second solution is working however it is applying to whole sheet but user need set the for only one measure not all.. ( i.e. the trigger selection should be applied to only Customer visits. any ides how we can restrict to only one measure.

Cheers,

Raghav

Default value for expression

Thu, 07 Jan 2010 16:24:01 GMT

Hi Raghav,

Could you attach an example file?

Thanks.

Default value for expression

Fri, 08 Jan 2010 10:44:48 GMT

Hi,

If your users table has the same access names as the salesman you can capture the logged user to variable and then contraint the customers visits to that name as well. It is a possibility worthwhile to explore mainly if you don't want to reduce the data set by login and most important if the initial filtering shoul only apply to the customers visits and not to the entire document.

The other way is to it through a macro but I don't have enough knowledge about such aspects

Hope it helps

Regards

Joao