Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Mapping an expression to an external table.

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,

R

4 Replies
MVP
MVP

Re: Mapping an expression to an external table.

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

creating an age group from a date field

Not applicable

Re: Mapping an expression to an external table.

I think your case may be similiar to this:

pick rating on the fly using calculated score

regards

Darek

Not applicable

Re: Mapping an expression to an external table.

Thanks, will look into it. Much appreciated.

Not applicable

Re: Mapping an expression to an external table.

Thanks, will look into it. Much appreciated.