topic Re: a AND b NOT c in QlikView

a AND b NOT c

Thu, 18 Apr 2013 05:37:00 GMT

Hi,

Let say that I have a Transaction table that contains customer name, product name, and price.

Name	Product	Price
Andy	Shoes	100
Brett	Shirts	200
Robert	Shoes	300
Robert	Shirts	350
Robert	Laptop	1000
Andy	Shirt	200
Brett	Shoes	200

I want to be able to display this data in QlikView Dashboard and I want the user to make a selection visually for a person that buy shoes AND shirts but NOT laptop

which if done correctly will result in Andy and Brett.

Any guidance how to do this? Do I need to apply macro?

Thanks!

Re: a AND b NOT c

kaushiknsolanki — Thu, 18 Apr 2013 06:15:11 GMT

Hi,

Have a look at the application.

Here user can enter the products which should be included and which should be excluded.

Regards,

Kaushik Solanki

Re: a AND b NOT c

sushil353 — Thu, 18 Apr 2013 06:19:01 GMT

Hi,

Try this:

MaxString({<Name=e({<Product={'Laptop'}>}Name)>}Price)

PFA application.

HTH

Sushil

Re: a AND b NOT c

jagan — Thu, 18 Apr 2013 06:20:12 GMT

Hi,

Please find attached file for solution.

Hope this helps you.

Regards,

Jagan.

Re: a AND b NOT c

Gysbert_Wassenaar — Thu, 18 Apr 2013 06:22:54 GMT

See attached qvw

edit: In the chart Name is used as dimension and this hidden expression:

sum({<Name=p({<Product={'Shoes'}>}Name)>*

<Name=p({<Product={'Shirts'}>}Name)>*

<Name=e({<Product={'Laptop'}>}Name)>}1)

The expression selects only those names that have Shoes and Shirts and not Laptop.

Re: a AND b NOT c

Thu, 18 Apr 2013 07:06:23 GMT

Hi,

Use Alternate States

See attached qvw

Re: a AND b NOT c

Thu, 18 Apr 2013 07:15:30 GMT

Hi Kaushik,

Unfortunately, I can't open your document.. can you explain the approach? Thanks

Re: a AND b NOT c

Thu, 18 Apr 2013 07:15:54 GMT

Hi Gysbert,

Unfortunately I can't open the document, can you explain your approach? Thanks..

Re: a AND b NOT c

kaushiknsolanki — Thu, 18 Apr 2013 12:51:18 GMT

Hi,

Use this expression.

sum({<Name = e({<Product = {"$(vNotProduct1)"}>}),Product = {"$(vProduct1)","$(vProduct2)"} >}Price)

Where vNotProduct is a variable where user will enter which product not bought, same vProduct1 and vProduct2 are other variables where user will enter the product which is bought.

This makes it more dynamic where user can actually drive this.

Hope the idea is clear.

Regards,

Kaushik Solanki