topic Re: How can make selections based on filter for expression in QlikView

How can make selections based on filter for expression

Tue, 18 Nov 2014 10:21:25 GMT

I have created dashboard based on emp data.

it contains empno,ename,sal fields and i have created empno as filter.

i have creted stright table for represent salary based on ename.

But i need to calculate setanalysis if i select filter as empno then i need to sum of salary on table otherwise i need to show based on ename how can i place in expression plesae give me example?

Re: How can make selections based on filter for expression

Tue, 18 Nov 2014 10:26:43 GMT

try this

sum({<empname=}>}sales)

Re: How can make selections based on filter for expression

ashfaq_haseeb — Tue, 18 Nov 2014 10:30:24 GMT

May be like this

Regards

ASHFAQ

Re: How can make selections based on filter for expression

Tue, 18 Nov 2014 10:44:46 GMT

Hi,

Sum({<ename=}>} sal) ----it will give which u select the empno that sales only.

Sum({<empno=}>} sal) ----it will give which u select the ename that sales only.

Sum({<ename={'*'}>} sal) ----it will give all ename that sales only.

Sum({<empno={'*'}>} sal) ----it will give all empno that sales only.