topic Re: Need some help in App Development

Need some help

Thu, 15 Jun 2017 05:29:37 GMT

I have below questions

1) I have 4 charts in sheet, when I select value in filter only three charts should be change and fourth chat will not be reflected. How can we achieve this.

2) When we have compound key in the script, how the incremental load will process?

3) I have top 5 products in bar chart based on sales, Now I want display their sum sales value as KPI .

Regards,

Ram

Re: Need some help

kaushiknsolanki — Thu, 15 Jun 2017 08:35:07 GMT

Hi,

Find the comments for respective questions below.

1. This can be achieved using the Set Analysis in Qlik.

2. This depends on the scenario. But you can have a look at the incremental script in below link.

Incremental loading - All scenarios

3. This you can code using the set analysis.

Regards,

Kaushik Solanki

Re: Need some help

slondono — Thu, 15 Jun 2017 12:44:53 GMT

1. You can ignore the selections with Set Analysis. For example Sum({<Year=>}Sales). That will ignore the selections in the fiel Year. Or you can use Alternate Estates

2. I dont really know n,nU

3. Kaushik, you can not do it with set Analysis because the top are dynamical. Maybe something like Numsum(Substring(Text_with_the_values in order,',',4)) but i dont really know in this moment how to order the values in a text string