Newbie Question. Is it possible to clear data displayed on a pivot table when no item/s selected ?

[markticoy]

Good day everyone,

I've been studying Qlikview 11 for a week now, and I'm wondering if it is possible to hide / don't show data on pivot table if nothing is selected (no date/sales person/item selected) ?

Thank you.

[jagan]

Hi,

Try this expression

If(Len(GetFieldSelections(date) ) > 0 AND Len(GetFieldSelections([sales person]) ) > 0 AND Len(GetFieldSelections([sales person]) ) > 0, Sum(MeasureName), Null())

Note: Replace MeasureName with your actual field which you are aggregating.

Regards,

Jagan.

[oknotsen]

I suggest you use a conditional show. This can be done for the whole chart (see General tab) or for individual expressions (see top-right in the Expression tab). Inside those fields add an expression that that results in either "true" or "false".

If you are going to use conditional show in the general tab, be sure to also edit the error message (see button at the bottom of the general tab) and change it into something that tells your user what he/she is supposed to do to get results in the chart.

[jonathandienst]

Hi

You could use a calculation condition (on the chart properties | general):    

If you need a selection in all 3:

=GetSelectedCount(datefield) > 0 And GetSelectedCount([sales person field]) > 0 And GetSelectedCount(itemfield) > 0

If you need a selection in any 1:

=GetSelectedCount(datefield) > 0 Or GetSelectedCount([sales person field]) > 0 Or GetSelectedCount(itemfield) > 0

HTH

Jonathan

[markticoy]

Thank you for your very helpful comments guys

[jagan]

Hi,

Are you trying this in Qlikview or Qliksense?  This is Qliksense Group, I think there is no such option (calculation condition)in Qliksense, it is available in Qlikview.

Regards,

Jagan.

[oknotsen]

My bad; I thought Pivot tables are not available (yet) in Qlik Sense and just blindly assumed it was a QlikView question.