Cannot get AGGR expression to work

[Anonymous]

Hi,

I asked a previous question on how to create a bar chart that displays 1 value but is filtered by another.

An expression was given (see below)

=if( RANK( Sum({$<[Requisition Status]={Closed}>}[Number of Filled Reqs]) )<=5,Sum({$<[Division]={'Lifestyle Audio'}>}[Approve to Close])/Sum({$<[Division]={'Lifestyle Audio'}>}[Number of Filled Reqs]))

The expression works but shows the countries that are not are not in the top 5.  I then got this instruction but I cannot get it to work

=AGGR(if(RANK(SUM(Sales))<=4,Country),Country) and then check suppress null values

Please help.Thanks,Kizzy

[sunny_talwar]

How about mocked up data? Doesn't have to use your original file... just any data showing the issue

[Anonymous]

HI,

I changed the expression to below and I changed the dimension to country but its still showing the same chart.

Thanks,

Kizzy

if( RANK(Sum({$<[Requisition Status]={Closed},[Division]={'Lifestyle Audio'}>}[Number of Filled Reqs]),[LS Countries])<=4,Sum({$<[Requisition Status]={'Closed'},[Division]={'Lifestyle Audio'}>}[Approve to Close])/Sum({$<[Requisition Status]={'Closed'},[Division]={'Lifestyle Audio'}>}[Number of Filled Reqs]))

[Anonymous]

Hi Sunny,

How do make a QVF file?

thanks,

Kizzy

[sunny_talwar]

Well how did you create the above application? That file is called .qvf

[Anonymous]

Hi Sunny,  I get that but how do I share it with you?

Thanks,

Kizzy

[sunny_talwar]

Check here

Uploading a Sample

[sunny_talwar]

And this to export your app

https://help.qlik.com/en-US/sense/1.1/Subsystems/ManagementConsole/Content/QMC_Resources_App_Exporti...

[Anonymous]

Sorry sunny but I am lost.  Please  clarify what exactly you are looking for.  I thought you wanted access to my app to test but you sent me instructions to upload attachments?

[sunny_talwar]

Apologize for confusing.... here is what I want

1) Create a new qvf file with mocked up data

2) and then share the file here so that we can take a look at this.

I don't need direct access to anything... just need a file where I can see the issue.

Does this make sense?

[Anonymous]

Hi Sunny,

I am working in the development site and don't have access to publish data. And from the instructions I can only share published data with you. This is done through a colleague (although I will request this access) is there any other way to answer this question in the meantime?

Thanks,

Kizzy