topic Conditional Show in QlikView

Conditional Show

Anonymous — Fri, 08 Dec 2017 16:27:44 GMT

I need to do a conditional show for an object.

The object shows up when the two conditions are met:

If there's only one item selected. Count (Distinct [ID]) = 1, and

when the value of a field [IsDiscounted?] = 'Yes'

I have difficulty combining these two conditions. Any idea?

Thanks

Yvonne

Re: Conditional Show

Anil_Babu_Samineni — Fri, 08 Dec 2017 16:36:20 GMT

May be this?

If(GetSelectedCount(item) = 1 and Count(DISTINCT ID) =1 and Match(IsDicounted, 'Yes'), 1,0)

Re: Conditional Show

petter — Fri, 08 Dec 2017 16:44:17 GMT

In the Layout / Show Conditional you can have the following expression:

=GetSelectedCount([ID])=1 AND Count(DISTINCT [ID])=1 AND [IsDiscounted?]='Yes'

Re: Conditional Show

sunny_talwar — Fri, 08 Dec 2017 16:45:21 GMT

Is it possible to have multiple IsDiscounted values when a particular ID is selected? And if it does, do you want to see this when all those values are 'Yes' or if any of those values are 'Yes'?

Re: Conditional Show

Anonymous — Fri, 08 Dec 2017 16:47:48 GMT

It's one isDiscounted value per ID

Re: Conditional Show

sunny_talwar — Fri, 08 Dec 2017 16:48:57 GMT

Then I would think any of the above two suggestions should work for you

Re: Conditional Show

Anonymous — Fri, 08 Dec 2017 16:51:34 GMT

Thanks for your answer:)

Do I need both GetSelectedCount([ID])=1 and Count(DISTINCT [ID])=1?

Are they the same?

Re: Conditional Show

sunny_talwar — Fri, 08 Dec 2017 16:55:48 GMT

They are almost the same...

GetSelectedCount(ID) = 1 will only show 1 when you have selected directly 1 ID from the ID field

Count(DISTINCT ID) = 1 will show 1 when you have other selection drill down ID to have only one possible value of ID. For instance you selected a region, which happen to have only 1 ID, this will show 1.

So, depending on your requirement, you can choose one of the two