Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Star is * NOT in section access

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?

Labels (2)
4 Replies
Highlighted
Specialist
Specialist

* 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.
To help community find solutions, please don't forget to mark as correct.
Highlighted

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,
	....
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Partner
Partner

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!

Highlighted
Digital Support
Digital Support

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/Scr...

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.