Want to show a chart or a table only when a selecton is made

[#1]

Hi Guys,

I am very new to qlikview. So, this might be something very basic.

I want to show a pivot table only if a selection is made( only if a Metric is selected ) .. so the expression i have is..

Sum ( {$<Metric={$(=Only(Metric))}>} YesterdayActual)

So, basically i am doing a sum of YesterdayActual and i am doing it only if one Matric is seleted.

Bear in mind that Metric is a Text Filed .

This was working for some other requirement ....

Sum({$<Year={$(=Only(Year))}>} LineSalesAmount) this was working fine....

the only difference is that 'Year' is a number filed and 'Metric' is a text field.

Please help me in this regard.

Thanks,

Vishnu

[rwunderlich · Accepted solution]

This is typically done in the on the Layout tab of the object properties and adding a "Show Conditional".expression.

For example

=GetPossibleCount(Metric) = 1

If you want to show the chart if only one Metric is possible.

Or

GetSelectedCountt(Metric) = 1

if you want to require that an actual selection was made before showing the chart.

-Rob

[#3]

Hey Rob,

Thanks you so much. You really helped me:)

Thank you once again. I really appreciated.

Its working perfectly 🙂

Thanks you,

Vish