topic Re: Conditional Visualization in QlikView

Conditional Visualization

Frquiroga1995 — Wed, 28 Apr 2021 17:39:26 GMT

Hi !

I am creating a visualization in the front part of Qlikview, and there are a lot of text objects.

Imagine this database:

Case Number / Case Type

10 / Endoso

2 1 / Solicitud

13 / Solicitud

54 /Endoso

etc / etc

In the front, the user only has to write a case number in a "search object". If and only if, that case number is related to a Case Type = 'Endoso' I want a text object that gives information of another data base related to Case Type (the relation is already made in the script) appear.

I know if you go to the design part of the text object, you have to put conditional and then write the condition:

Ive tried using this: GetCurrentField(Case Type) = 'Endoso' but it didn't work.

I would really appreciate if you can help me.

Thanks !

Re: Conditional Visualization

jwjackso — Wed, 28 Apr 2021 18:25:54 GMT

In the conditional field,

If(GetSelectedCount([Case Number]) = 1,If(Count({<[Case Type]={'Endoso'}>}[Case Type]) > 0,1,0),0)

The GetSelectedCount is to verify that a [Case Number] has been selected.

Re: Conditional Visualization

JuanGerardo — Wed, 28 Apr 2021 19:06:34 GMT

Hi @Frquiroga1995, maybe with GetFieldSelections ()?

GetFieldSelections([Case Type]) = 'Endoso'

Re: Conditional Visualization

Frquiroga1995 — Thu, 29 Apr 2021 17:34:06 GMT

That worked perfect ! Thank you so much!