topic Re: Pls give me set expression for this scenario? in QlikView

Pls give me set expression for this scenario?

Thu, 26 Jun 2014 10:01:15 GMT

I have a table like

TABLEA:

productid,

productname,

sales

i have a chart with these dimension using pid,pname as a dimensions and sum(sales) as expression

My requirement is when i go for click on product name chart should nit get any changes?

Pls write a expression for this?

Gysbert_Wassenaar — Thu, 26 Jun 2014 10:02:36 GMT

sum({1}sales)

MK_QSL — Thu, 26 Jun 2014 10:04:29 GMT

SUM({1}Sales)

SUM(ALL Sales)

CELAMBARASAN — Thu, 26 Jun 2014 10:12:01 GMT

Hi,

If you want to ignore all field selections in dashboard, you can use

Sum({1} Sales)

If your need is like to restrict the selection happens only in product name field then

Sum({<productname=>} Sales)

MayilVahanan — Thu, 26 Jun 2014 10:13:37 GMT

Try like this

Sum({<productname=>} Sales)

Sum({1} Sales)

SunilChauhan — Thu, 26 Jun 2014 10:14:12 GMT

remaining as you are using

only expression use this

sum({<productname=>}sales)

not sum({1}sales) it will hide other selections also

hope this helps