Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter on a pivot table


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?

1 Solution

Accepted Solutions
jonathandienst

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

8 Replies
ashfaq_haseeb

Hi,

If it is number no need to enclose in ''

Ex

PostingYear={2014}


Will work


Regards

ASHFAQ

Not applicable
Author

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

israrkhan
Specialist II
Specialist II

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...

Not applicable
Author

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

Not applicable
Author

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

giakoum
Partner
Partner

Do you have a project name and a project id?

jonathandienst

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

Not applicable
Author

PERFECT!!

Thats worked like magic! Thanks Jonathan

Nas