Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hopkinsc
Valued Contributor

Help with when to display data

Hi,

i have a straight table that i only want to populate with results when selections have been made from my selection criteria.

Here is an explanation of what i am trying to do...

I have a RETAILER SELECTION where the user selects 1 or more selections i,e. RETAILER NAME, REGIONAL MANAGER, SOFTWARE VERSION, CUSTOMER TYPE etc

Once at least 1 selections have been made, my STRAIGHT TABLE populates with various retailer information.

I only want the straight table to populate AFTER a selection has been made. So until a selection is made, the straight table will be blank.

Is this easy to do?

Thanks for your help..

Tags (1)
7 Replies
Not applicable

Help with when to display data

Hi

Here you can do it.

General tab

Calculation Condition.

Anders

hopkinsc
Valued Contributor

Help with when to display data

Thanks, But what condition would i type?

Not applicable

Help with when to display data

Hi

I have done it when one have to select only one country.



count

Maybe that can help you

Anders

(distinct(COUNTRYNAME)) = 1



hopkinsc
Valued Contributor

Help with when to display data

Hi again,

That worked, but if i select more than one of the retailer options, it hides all results.

I want it to show results if 1 OR MORE selections have been made, not show results if only 1 selection have been made.

Any ideas?

I have tries using <=0 but with no luck..

Not applicable

Help with when to display data

I think you should write this as Condition:

Count(distinct RETAILER NAME )>= 1
Or Count(distinct REGIONAL MANAGER) >= 1
Or Count(ditinct SOFTWARE VERSION) >= 1


I hope it helps.

Regards,

Miha

Not applicable

Help with when to display data

You should actually try this way:



not

And not IsNull(GetFieldSelections(REGIONAL MANAGER,','))

...

This is a better way, because the previous version did not work if nothing was selected...

Regards,

Miha

IsNull(GetFieldSelections(RETAILER NAME,','))



Not applicable

Help with when to display data

the previous post is messed up, so once again (hope it will be better now Smiley Wink:

  • not IsNull(GetFieldSelections(REGIONAL MANAGER,',')) And not IsNull(GetFieldSelections(RETAILER NAME,','))