Referencing visual cues in a straight table

[Anonymous]

Dear community,

I would like to add an expression to a straight table that checks whether the visual cue in another column of the same row is active or not.

All values below 80% are green. Can I add a column where QlikViews checks if the visual cue is active or not?

I can not reuse the expression with an if function like

If(fabs(Sum({$<[FS Item]={'1180000'}>}([Period Value GC]))) < 0.8, 'visual cue active')

as I am using "full accumulation" and "relative". The above expression only returns 'visual cue active' when the
actual value is smaller than 0.8 €, regardless of the accumulated percentage.

Thank you in advance.

Best regards,

Mats

[Anonymous]

Hi Mats,

just create a better example, with all the fields that are used as dimensions and within expressions....

Preparing examples for Upload - Reduction and Data Scrambling

--> you can scramble confident fields or replace them manually with random data...

Regards Robin

[Anonymous]

The data reduction and scramble tools are quite effective, I thought it would take far longer to adjust the file.

Please find it attached.

[prieper]

Should be like the attached?

Peter

[Anonymous]

I would like to mark every company that is within the 95% range (or any other percentage, determined by the variable in the input box) with "1" or similar.

As you can see there are 6 accounts (tables in the container object) in total, I would like to first assign the value (e.g. 1) so that I can build a sum column. The insight the user is looking for can be described as

"If I audit Company A, how much of the deferred tax assets, current income tax receivables etc. is covered?"

You want to audit only those companies that are in the chosen %range in as many of the 6 accounts/categories as possible.

The final (total) table should provide information like

Company                Number of categories(accounts) where the company is within %range

A                            5

C                            3

I hope that makes sense.

Thank you in advance.

Mats

[Anonymous]

So no matter if I use visual cues or the text color option, in the end I want to count the amount of times the company is within the chosen %range.

[prieper]

Dann gebe doch bitte mal ein Beispiel mit input und gewünschtem output.

[Anonymous]

Das wäre als Output der Hilfsspalte vollkommen ausreichend. So könnte ich nachher die Hilfsspalten aufsummieren

und die Aussage treffen: Company XY ist in 4/6 Fällen in der gewählten Range.

[prieper · Accepted solution]

so in etwa?

[Frank_Hartmann]

versuche es mal mit dieser Formel:

If(RangeSum(Above( (Sum({$<[FS Item] = {'1180000'}>}[Period Value GC])),0,RowNo()))/

    Sum( TOTAL{$<[FS Item] = {'1180000'}>}([Period Value GC]))<=0.95,1,0)

[Anonymous]

Hallo Peter,

ja, das geht genau in die richtige Richtung!

Das einzige verbleibende Problem ist, dass er mir die Sortierung verhaut, wenn ich die neuen Funktionen verwende (DTA Betrag soll ja absteigend sortiert sein). Hat jemand eine Ahnung, woran das liegen könnte? Auf dem Sortieren-Tab habe ich alle anderen Optionen entfernt.