topic Re: Filter on a pivot table in QlikView

Filter on a pivot table

Tue, 05 Aug 2014 13:38:20 GMT

Hi Guys,

Need some help. I have the following expression in the pivot table :

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project={"S17*"}, PostingYear={'2014'}>}Cost)

However within the table i cant filter on any individual Project. I have a set analysis, which only shows projects which begin with S17, however i cant filter on a individual one.

Any ideas?

Re: Filter on a pivot table

ashfaq_haseeb — Tue, 05 Aug 2014 13:40:35 GMT

Hi,

If it is number no need to enclose in ''

PostingYear={2014}

Will work

Regards

ASHFAQ

Re: Filter on a pivot table

Tue, 05 Aug 2014 13:43:46 GMT

Hi Naheem,

Maybe you could try "+=" after Project instead of "=". You will have red underline syntax error but it is a bug on syntax check.

If you put += that means that it will show what is selected plus your selection in set analysis. :

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project+={"S17*"}, PostingYear={'2014'}>}Cost)

Patrick

Re: Filter on a pivot table

israrkhan — Tue, 05 Aug 2014 13:47:12 GMT

because you have fixed projects in the set analysis.

if you wana filter, you wana see for selected project than remove it from expression.

try like ({$<VendorNo={'1.....'}, KSTAR%={'.......'}, PostingYear={'2014'}>}Cost)

and please increase your font size in next posts, its very diffucult to read such a small font and type.

Hope it Helps....

or can you please attach the sample doc...

Re: Filter on a pivot table

Tue, 05 Aug 2014 13:47:46 GMT

Hi Patrick,

Just tried that however that brings in all other projects not beginning with S17 in the table, which i dont want im afraid....

Nas

Re: Filter on a pivot table

Tue, 05 Aug 2014 13:53:51 GMT

hi,

Thank you for this. The only issue is i dont want other projects in the table. Only those projects that begin with S17. However if i do this, i cant filter on individual project in the pivot table

Re: Filter on a pivot table

giakoum — Tue, 05 Aug 2014 13:57:34 GMT

Do you have a project name and a project id?

Re: Filter on a pivot table

jonathandienst — Tue, 05 Aug 2014 13:57:45 GMT

As I understand it, you want the chart to display all projects starting with S17, end then be able to select one project that starts with S17. I think you need an intersection rather than a union (see the asterisk below)

({$<VendorNo={'1.....'}, KSTAR%={'.......'},Project*={"S17*"}, PostingYear={'2014'}>}Cost)

However, be aware that this will exclude everything if you manually select a project that does not start with S17, because there will be no values in the intersection. You may want to use a conditional show or calculation and/or a popup warning to advise the user when this happens.

HTH

Jonathan

Re: Filter on a pivot table

Tue, 05 Aug 2014 14:07:30 GMT

PERFECT!!

Thats worked like magic! Thanks Jonathan

Nas