If a field is used in set analysis then can same field is used for filter pane and does selections work?

[gadgedee]

Hi,

I am new to qlik view and creating a straight table where I am using following expression :

count( { $<Environment = {'Production'}, [Change Tool]= {'TCM2'} , [IT Owning Super Division] = {'Technology', 'Company'},  GRN = {'grn:/ms/ei/edc/facilities','grn:/ms/ei/edc/imac','grn:/ms/ei/edc/mande','grn:/ms/cs/csFacilities','grn:/ms/cs/csMandE'} , Severity = {'Critical','High','Moderate'}> } distinct TCM)

In this I am trying to filter the data in straight table to always limit to show few GRNs specified in above expression.

It is working fine.

Now I am trying to give GRN as a filter outside this straight table in same sheet. Now GRN field also displaying only 5 values as mentioned in above expression, i.e.

'grn:/ms/ei/edc/facilities','grn:/ms/ei/edc/imac','grn:/ms/ei/edc/mande','grn:/ms/cs/csFacilities','grn:/ms/cs/csMandE'.

But when I select any these GRNs in filter pane, the table is not changing as per my selection. I want to display the table only now those records and count of TCM based on my GRN selected.

Can someone please help? or this is not possible.

I am using qlik plugin so have limitations and cannot access backend script, but only dimensions and measures readily available.

Thanks,

[vishsaggi]

Remove GRN field from your set analysis and see if that helps.

count( { $<Environment = {'Production'}, [Change Tool]= {'TCM2'} , [IT Owning Super Division] = {'Technology', 'Company'}, Severity = {'Critical','High','Moderate'}> } distinct TCM)

[gadgedee]

Thanks Vishwarath.

But I want to limit data in tables to only 5 GRNs always out of total 10. And then I want to use GRN as filter for those 5 GRNs so that I can get count for each GRN ( within that 5 GRNs) when selected.

And Table will also show data for only selected GRN. ( which is again out of 5 mentioned in expression)

Hope I am able to explain it.

Regards,

[vishsaggi]

Use those 5 GRNs in one of your dimensions as calculated dimensions. Can you share a sample file so that will be easy to work on.

[tamilarasu · Accepted solution]

Hi Deepali,

count( { $<Environment = {'Production'}, [Change Tool]= {'TCM2'} , [IT Owning Super Division] = {'Technology', 'Company'},  GRN *= {'grn:/ms/ei/edc/facilities','grn:/ms/ei/edc/imac','grn:/ms/ei/edc/mande','grn:/ms/cs/csFacilities','grn:/ms/cs/csMandE'} , Severity = {'Critical','High','Moderate'}> } distinct TCM)

Use intersection operator.

[gadgedee]

Thank youTamil.

It is working perfect !

Thanks,

Deepali

[gadgedee]

Thanks Vishwarath for your suggestions as well.

Let me try this  may be that's same work around as Tamil has suggested.

But just to let you know intersection operation is working fine.

Thanks,

Deepali