topic hOW TO FILTER DATA BY CHECKBOX in QlikView

hOW TO FILTER DATA BY CHECKBOX

Mon, 03 May 2010 09:27:10 GMT

Hello,

i want to build a dynamic dashboard so as to select dimensions dynamically as below image. is that possible in QVW, please?

Thanks in advance

Ashish

hOW TO FILTER DATA BY CHECKBOX

Mon, 03 May 2010 10:10:52 GMT

Hi Ashish

Is your question related to the exact layout your showing or to the function of allowing users to select dimensions?

For layout you can try Document Properties/General/Selection Appearance/Windows Checkboxes and according subtables to contain your options for selection. You can format list boxes to be in horizontal mode too.

For function you might want to set the expression enable flags for the selected values with a macro. You can find examples in the API guide document (e.g. Automation Examples, search for *expressiondata*).

set cp = chart.GetProperties
set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionData
expr.Enable = false 'disable first expression
chart.SetProperties cp

Regards

Jürg

hOW TO FILTER DATA BY CHECKBOX

prabhu0505 — Mon, 03 May 2010 10:12:33 GMT

hi Ashish

To the best of my knowledge, there is no check box object in Qlikview, but you can instead use buttons or list boxes to perform this.

And also there is a type of object(custom object) using which we can develop our own object by vb and use it. This is just an idea, I haven't tried this so far.

hOW TO FILTER DATA BY CHECKBOX

Mon, 03 May 2010 10:47:55 GMT

Hi Jurg,

Thanks for the answer. I was looking for a way to select dimension interractively. Seems its not an easy thing without macro.

Thank again,

Cheer!!

Ashish

hOW TO FILTER DATA BY CHECKBOX

Mon, 03 May 2010 10:54:27 GMT

Hi Prabhu,

thanks for answering. Gonna try it.

Cheers

Ashish

hOW TO FILTER DATA BY CHECKBOX

johnw — Tue, 04 May 2010 01:09:42 GMT

I am unclear exactly what you're trying to do, perhaps because of language issues trying to read your chart. But it appears that your dimension is always the same (month), and you're just selecting which values you want to see. That's basic list box functionality. You can make list boxes appear as a list of check boxes, but I suggest against it, as it takes more space, and your users should learn to use QlikView's objects. It also appears that you're combining two dimensions into one, which is a simple matter of concatenating them together. I'd do that during the load, but you could do it as a calculated dimension in the chart if you prefer. I guess I'm not seeing anything unusual in terms of functionality, only in terms of display (checkboxes).