Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Partner
Partner

SubstringCount is not working in below scenario

Hello Friends!

Please check below scenario.

Please check table TABLE1 in attached Excel

I’m providing X,Y values from filter pane, and able to find sum of actuals for X,Y company (table 1)

But ADJ value needs to be arrived based on COMPANY_GROUP & KNOCK-OFF COMPANY GROUP (KNOCK-OFF COMPANY GROUP, which is same as COMPANY_GROUP values like ‘X’,’Y’,’Z’,’K’)

When selecting MULTIPLE COMPANY_GROUPs from FILTER PANE,

From those above tables, trying to arrive TOTAL (RESULT tab),

But while arrive ADJ value, need to check whether KNOCK-OFF COMPANY GROUP (Y,V,W)is fallen under

COMPANY_GROUP combination selected {Here COMPANY_GROUP  as of now it’s (X,Y,Z)}.

For this, Variable I declared from Filter pane input as

Vconcat = CONCAT(DISTINCT COMPANY_GROUP,’,’)

But need to compare the Vconcat everytime with Knock off company group like below

SUM(If(SubStringCount(Vconcat,[ KNOCK-OFF COMPANY GROUP] )>=1, ADJ,0)).

Using pivot for this.

Is not working. Any suggestion highly appreciated.

 

 

 

2 Replies
Highlighted
DavidŠtorek
Contributor III

Re: SubstringCount is not working in below scenario

Hi,
could you try to explain your logic in some different way? Maybe with more data. I can't get what you are trying to achieve.
rajaiqliksense
New Contributor

Re: SubstringCount is not working in below scenario

Thanks Mr. Dave.

I got other solution by placing extra Filter pane and changed my Data also according to the requirement.