Unable to get expected rows using show hide function.

[Karim_Khan]

Hi Folks,

I am trying to get the no.of rows based upon non-null values of specific field.

Assume that when month is selected it should show no.of rows asscoiated with non null Broker Quote column and when selection is released it should show all values i.e null and non-null Broker Quote field records in straight table.I am trying to achive this using calculated dimenssion or show hide functionality but its not working.

Note : If no selection is made then count is getting matched but when doing granular level selcetion i.e month wise then count is getting mismatched.

PFA for reference.

Regards,

KK

@qlik @Mvp @Gysbert_Wassenaar @tresesco 

[igoralcantara · Accepted solution]

Hey Karim,

To show the number of rows associated with non-null Broker Quote column values when a month is selected and showing all values (both null and non-null) when no month is selected, you can use set analysis in Qlik Sense. 

1. Add a Field to Identify Non-Null Broker Quotes.
if(len(trim([Broker Quote])) > 0, 1, 0) as BrokerQuoteFlag

2. Use Set Analysis in Your Measure:
Sum({<BrokerQuoteFlag = {1}>} YourMeasure)

3. Use a conditional dimension to show or hide rows based on the BrokerQuoteFlag field.
if(GetSelectedCount(MonthField) > 0, if(len(trim([Broker Quote])) > 0, [YourDimension], null()), [YourDimension])

4. Handle the Case When No Month is Selected:
You can use a combination of GetSelectedCount and conditional logic in your expressions to ensure the correct rows are shown based on the selection.

I hope this gets you closer to your solution.