Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akpofureenughwu
Contributor II

SubStringCount function on qliksense

Hello everyone,

Can =SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|') expression work on qliksense? If yes , how?

I tried using the conditional function on qliksense but it didn't work well for me.

I want to do conditional hiding on qliksense. How can I do it?

In qlikview, I use =SubStringCount('|' & Concat(distinct Dimension, '|') & '|', '|Company|')

Regards

3 Replies
agigliotti
Honored Contributor II

Re: SubStringCount function on qliksense

it's not possible to hide an object in Qlik Sense.

Re: SubStringCount function on qliksense

Show and hide is not available in default functionality, but you can try below extension.

https://github.com/fadyheiba/ShowHide

Regards,

Kaushik Solanki

agigliotti
Honored Contributor II

Re: SubStringCount function on qliksense

for your needs you could use also the below extension:

http://branch.qlik.com/#!/project/58e20b0e86f54ab8e8f21512

that enable you to fire a trigger actions opening a sheet.