topic Re: Problem with full set {1} in QlikView

Problem with full set {1}

Anonymous — Thu, 12 Mar 2015 18:36:54 GMT

Helo,

In attached qv doc, in Table2 straighttable, I am trying to show Parts, corresponding weight and no of suppliers. If I make a selection in Vehicle, Part or Supplier fields I want Table2 to show rows related to the selection however the no of suppliers should be unaffected.

for this i put "count({1} distinct Supplier)" as "no of suppliers" expression. with this the supplier count is unaffected but extra rows show up when i do filtering.

For example if I select Part = P1, I should only get P1 record in Table2 but I get P1 and P3.

Can someone pls tell me why this behavior?

Thanks,

Re: Problem with full set {1}

Thu, 12 Mar 2015 19:17:07 GMT

Hi,

try to use following expression

count({<Supplier =>} distinct Supplier)

it will ignore your selection in Supplier but will react on selection in Part.

If you need to ignore also vehicle please do count({<Supplier =, Vehicle=>} distinct Supplier)

Re: Problem with full set {1}

Anonymous — Thu, 12 Mar 2015 19:32:52 GMT

That works. Thank you.

If there is a scenario where I want to ignore all filters and if there are too many of them, what would be the best way to do this?

Re: Problem with full set {1}

sunny_talwar — Thu, 12 Mar 2015 20:26:51 GMT

For ignoring all filters you would use {1}, for more specific requirements you can look at the following attached document (page 18)

Copying a small extract from the document:

If I want everything (All values) except for 2 dimensions: PRODUCT and MONTH, I would write:

=sum({$<[$(=Concat({1<$Field-={'PRODUCT','MONTH'}>}distinct $Field,']=,[' )&']=')>} VALUE)

HTH

Best,

Re: Problem with full set {1}

Anonymous — Fri, 13 Mar 2015 20:39:53 GMT

count({<Supplier=>} distinct Supplier) worked partially. The count is correct now but I still see extra unrelated rows when I select Supplier filter.

For ex, if I select Supplier S1, I should see only Part P1 but I see Part P3 also with corresponding values shown as null.

Does anyone know why this happens?

Re: Problem with full set {1}

Sat, 14 Mar 2015 07:27:11 GMT

Hi,

you will put in expression $ instead of 1. like this.

=count({$} distinct Supplier)

Re: Problem with full set {1}

PrashantSangle — Sat, 14 Mar 2015 08:11:21 GMT

Hi,

did you try with TOTAL keyword...

Regards

Re: Problem with full set {1}

Anonymous — Mon, 16 Mar 2015 17:53:37 GMT

Total doesnt help because I still want to use the groupby of the table.

count({$} distinct Supplier) gives me 1 if I select a supplier but I want the total suppliers of the part irrespective of the selection.

It almost looks impossible to have a field to filter the rows and still have count unaffected by the filter.