topic please help: condition on button to display heatmap in QlikView

please help: condition on button to display heatmap

sayadutt — Sun, 21 Sep 2014 17:46:57 GMT

Hi All,

I have a heapmap which shows some expression.

Now my requirement is to create a filter (button will also do). so that it only shows based on a condition.

for eg. After we select the filter/button, it should only show projects which has End Date in past, if we unselect the filter it should show All. (default page load feature)

End Date is one of the field that i have.

please help.

Re: please help: condition on button to display heatmap

ecolomer — Sun, 21 Sep 2014 17:50:34 GMT

you should use the conditional field of graphics so that only displays it when termination_date < selected_date

Re: please help: condition on button to display heatmap

sayadutt — Sun, 21 Sep 2014 17:59:42 GMT

Hi Enrique.

Thanks for replying.

If I apply condition on heatmap, then it will always show the filtered data. I dnt want that. By default it should show All. It should only filter when I click a button (say)

Re: please help: condition on button to display heatmap

nagaiank — Sun, 21 Sep 2014 18:20:49 GMT

In the expression for the heatmap, use a variable whose value is manipulated by the action on the button, e.g.,

Count({$<$(IncludAll)>} Project)

The variable IncludeAll will be set to

termination_date = {"<$(Max(termination_date))"}

when the button is clicked else

termination_date =

Re: please help: condition on button to display heatmap

sayadutt — Sun, 21 Sep 2014 18:29:27 GMT

I have added the expression in the heatmap.

Can you please guide how to set up the button

Re: please help: condition on button to display heatmap

Sun, 21 Sep 2014 18:48:25 GMT

Hi ,you should put the expression there, hope thi help

Matteo

Re: please help: condition on button to display heatmap

sayadutt — Sun, 21 Sep 2014 19:28:59 GMT

Apolozise, I am very new to qlikview. Can you please give an end to end steps.

Button on click should show this:

Projects where End Date <= today()

Re: Re: please help: condition on button to display heatmap

Sun, 21 Sep 2014 21:51:56 GMT

Hello, here an example, try if this can help you, there is a button that fire a macro that toggle the selection of

a finish date according the today date.

let me know if this is what you was looking for.

best regards

Matteo