Qlik Community

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF). Providing best practices, libraries and utilities that facilitate the recommended setup and management of QlikView or Qlik Sense environments. An understanding of the Qlik platform is recommended before joining this group. Download QDF and documentation here: https://github.com/QlikDeploymentFramework/Qlik-Deployment-Framework/releases

zain16nib
New Contributor III

Count of Growth Label

Hi,

i need to create a Report 2, format which is given in attached excel file.

kindly guide,

application and data file has been attached.

Thanks in advance,

Regards,

Zain.

Tags (1)
4 Replies
Highlighted
zain16nib
New Contributor III

Re: Count of Growth Label

i want to do this in dashboard not in script, i know this script level.

Thanks,

Zain.

zain16nib
New Contributor III

Re: Count of Growth Label

waiting for reply

Re: Count of Growth Label

How below are calculated?

 

0-502
above 503

Update - My Bad, Why you want only Front End??

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Count of Growth Label

Try this

Dimension

=Aggr(
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<0,'Negative',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)=0,'Zero',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>0 and (((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)<=50,'0-50',
if((((Sum ([2018])-Sum ([2017]))/Sum ([2017]))*100)>50,'above 50'))))
, br)

Expression

=Count(DISTINCT br)

Capture.PNG