topic Mapping an expression to an external table. in QlikView

Mapping an expression to an external table.

Fri, 18 Apr 2014 09:55:50 GMT

Hi folks,

Is it in anyways possible to map a calculated expression to an external table?

For e.g., what am trying to do is, after calculating the no. of days a user has used a service, for instance 64 days to map that particular output to a table where an ActiveMonths_GROUPING column which has a description that the particular user has been actively using the services lies in a particular group known as the 1-3 Months Active group.

I know I kinda suck at explaining the situation am in right now, but do bare with me here.

Thanks in advance.

Best Regards,

Re: Mapping an expression to an external table.

swuehl — Fri, 18 Apr 2014 10:58:41 GMT

You can look into a mapping approach, see here for a similar show case:

creating an age group from a date field

Re: Mapping an expression to an external table.

Fri, 18 Apr 2014 19:11:02 GMT

I think your case may be similiar to this:

pick rating on the fly using calculated score

regards

Darek

Re: Mapping an expression to an external table.

Mon, 21 Apr 2014 01:16:56 GMT

Thanks, will look into it. Much appreciated.

Re: Mapping an expression to an external table.

Mon, 21 Apr 2014 01:17:31 GMT

Thanks, will look into it. Much appreciated.