Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rajeshvaswani77
Valued Contributor III

Conditional hiding of Rows in table object - Urgent

Hi Community,

         I have a requirement related to the below table.

PolicyReference
P1V1
P1-
P2V2
P3V3
P4-
P5V4

The requirement is that ALL Policies that have a Reference and also have a NULL reference then we have to show Only the one that has a Reference.

Example : P1 has reference V1,NULL then we will show the row only for V1

On the other hand if there is a Policy that has one or many null references(none of the reference here have a value)

Example : P4 , then we display this policy.

The output required is like below. How do we achieve this?

PolicyReference
P1V1
P2V2
P3V3
P4-
P5V4

Thanks in advance,

Rajesh Vaswani

4 Replies
pat_agen
Valued Contributor

Conditional hiding of Rows in table object - Urgent

hi,

try using maxstring(Reference) as your expression.

make sure tjhe option suppress zero-values is not ticked on the presentation tab.

rajeshvaswani77
Valued Contributor III

Conditional hiding of Rows in table object - Urgent

Hi,

Thanks for the reply. If we use maxstring(Reference) then it will return only one value for that policy. But if i have more number of References for the same policy then i need to display all the references which are not null.

Also i am using table object here as we do not have any calculations.

Please suggest.

rajeshvaswani77
Valued Contributor III

Conditional hiding of Rows in table object - Urgent

Hi,

     Further to the question I has asked. In a simplified way this is what is expected.

Policy

Reference

Policy Count

NULL Flag

P1

V1

2

0

P1

-

2

1

P2

V2

1

0

P3

V3

1

0

P4

-

1

1

P5

V4

1

0

When Policy Count is greater than 1 and NULL Flag is 1(Reference is NULL) then we need to hide that row. Could someone help with a way/expression to do this?

Thanks,

Rajesh Vaswani

danielrozental
Honored Contributor II

Conditional hiding of Rows in table object - Urgent

What object are you using to display the table? simple table, pivot table or a table box?

If it's a table box you can just go to the presentation tab, select the reference field and select option "omit rows where field is null".

If you're using a chart then you can have either an if or a set analysis in the formula, something like if(not isnull(Reference),sum(value)) or sum({<Reference={*}>}value).

Community Browser