topic Re: Star is * NOT in section access in QlikView

Star is * NOT in section access

markmccoid — Sat, 16 Nov 2024 20:38:27 GMT

I'm loading a spreadsheet to define "Clusters" which are based on a Product / Type combination, however, some of the combinations that are needed are "anything" for the Type.

For example:

Product | Type | Cluster

P1 | T1 | Cluster1

P1 | * | CluterOther

So if P1 and T1 then "Cluster1" other wise all other Product P1 combinations with Type will be Cluster Other.

I tried using the Star is *; syntax, but it isn't working as expected.

Does anyone have any experience with this type of requirement?

Re: Star is * NOT in section access

Claudiu_Anghelescu — Wed, 19 Jun 2019 04:32:21 GMT

* means all the listed values, in your case only T1.

You have to concatenate all the distinct values with the section Access table from which you read the data.

Re: Star is * NOT in section access

jonathandienst — Wed, 19 Jun 2019 05:19:22 GMT

The STAR is * syntax only applies to section access. If you need to do this outside of section access, you will need to transform the data in your load script. There are several possible ways of doing this, for example:

MAP_CLUSTERS: Mapping LOAD * Inline [ Type, Cluster T1, Cluster1 ]; LOAD .... Product, Type, ApplyMap('MAP_CLUSTERS',Type, 'ClusterOther') as Cluster, ....

Re: Star is * NOT in section access

markmccoid — Wed, 19 Jun 2019 19:30:02 GMT

That was the information I needed. That it is only applicable in Section Access. The docs didn't explicitly state this so I wanted to make sure.

Thanks!

Re: Star is * NOT in section access

Brett_Bleess — Wed, 17 Jul 2019 19:42:29 GMT

I believe Claudiu was correct in this case, here is the help, and the reference is Section Access, but I think it should apply outside of Section Access as well, but I had another case recently here on Community where Henric Cronstrom provided some additional info too. Here is the Help link, which you may have already reviewed:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Star.htm

Article links:

https://support.qlik.com/articles/000003749

https://support.qlik.com/articles/000059866

Hopefully those may shed a bit more light on things for you.

Regards,
Brett