Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

проценты

Добрый день! помогите пожалуйста,  мне нужно чтоб в диаграмме показывалась разница в процентах с предыдуших годов (если конечно выбрано больше одного года ).     Покажу на примере :

Мне нужно чтоб показывало на сколько процентов выросла или упала продажа, помогите пожалуйста!

9 Replies
vinieme12
Champion III
Champion III

Use a Dual Expression

Example

DUAL (NUM ((Sum (Sales) - above (sum (Sales))) / Above (SUM (Sales)), '##. # 0%')

     , Sum (Sales))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
denis115
Creator
Creator
Author

I'm trapped, my expression is :

sum(SUMI)- sum(SUMRETURN)

Can you show how it will look with this expression please.

vinieme12
Champion III
Champion III


Try

=DUAL (NUM (

                        ( (sum(SUMI)- sum(SUMRETURN))- above ((sum(SUMI)- sum(SUMRETURN)) )

                              ) / Above ((sum(SUMI)- sum(SUMRETURN))), '##. # 0%')

     , (sum(SUMI)- sum(SUMRETURN)))



OR


Convert your chart into a combo chart

Add another expression that refers to the original expression and show this expression as a line with a transparent background i.e. ARGB,(0,0,0,0)


Exp1: (BAR)

sum(SUMI)- sum(SUMRETURN)


Exp2: (LINE)

DUAL (([Exp1]- above ([Exp1])) / Above ([Exp1]), '##. # 0%')

     , [Exp1])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

can you post a sample?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
denis115
Creator
Creator
Author

denis115
Creator
Creator
Author

what do you mean about sample?

vinieme12
Champion III
Champion III

Preparing examples for Upload - Reduction and Data Scrambling

a sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
denis115
Creator
Creator
Author

!

vkhassanov
Contributor II
Contributor II

Можно и без DUAL