topic Re: How to do a 'Contains' Formula in QlikView

How to do a 'Contains' Formula

Mon, 01 Jul 2013 13:20:27 GMT

I have a list of customers. However i want to create a chart/straight table showing only customers containing the word say , "Cars".

How do i do this.

Thanks

kind regards

Nayan

kaushiknsolanki — Mon, 01 Jul 2013 13:24:10 GMT

Hi,

You can use the set analysis to restrict the records.

Your expression should look like below.

Sum({<Customer_Name = {"*CARS*"}>}Sales)

Regards,

Kaushik Solanki

Mon, 01 Jul 2013 13:32:10 GMT

Hi Kaushik

Thanks. Your formula above relates to a value ..."Sales". Is there a way, without the value. Can you do an if formula.

kind regards

Nayan

kaushiknsolanki — Mon, 01 Jul 2013 13:38:30 GMT

Hi,

Set Analysis works same like if statement at brief, and its very powerful then if statement.

If statement in expression is not a best practice.

Regards,

Kaushik Solanki

rustyfishbones — Mon, 01 Jul 2013 20:00:53 GMT

Hi Nayan,

Checkout these videos on YouTube

IF WILDMATCH

pick wildmatch

calvindk — Mon, 01 Jul 2013 20:53:39 GMT

Create "Calculated Dimension" and put:

IF(WildMatch(Customer, '*CARS*') = 1, Customer, NULL())

Now Suppress NULLS on dimension.