List box to check fields

Fri, 21 Feb 2014 23:45:04 GMT

Hi All!

I need to create a list box that refers to particular fields. By making selection over there report(s) should be filtered to have only those records where particular values exist in corresponding fields.

For example,

Source data comes with separate fields for each kind of treatment A, B, C. Each treatment have many different values. Null and '0' means invalid or unknown. A user is interested to know if particular treatment was given and doesn't care what exactly was it.

Treatment
A
B
C


Fact
F1	A	B	C
ID4		4	0
ID1	0	0	1
ID3	0	56	0
ID2	1	3	6
ID5	2	1	2

So, when he chose a treatment 'A' from a list box 'Treatment' we should show (count, apply other logic) records from 'Fact' table where there are not Null and not '0' values in the field 'A'. That will be records with ID2 and ID5. If a user chooses all three values from a list box, all records will be displayed (considered) as they all have either one or another treatment.

How it might be achieved?

I tried creating a concatenated string to refer to a particular treatment if it was performed. But now I don't know how to make a trigger (use variables) to search if any element in GetFieldSelections('Treatment', ',') exists in that field?

My new string could be [A, , ,], [, , B, C], [ , , ,] and so on.

I greatly appreciate any help!

Thank you!

Re: List box to check fields

iktrayanov — Sat, 22 Feb 2014 01:22:24 GMT

Try using crosstable.

Re: Re: List box to check fields

MK_QSL — Sat, 22 Feb 2014 07:28:03 GMT

Like this?

Re: List box to check fields

Sat, 22 Feb 2014 11:54:16 GMT

Ivan, Manish,

Thank you! Crosstable is a solution here. And simple

topic Re: List box to check fields in QlikView

List box to check fields

Re: List box to check fields

Re: Re: List box to check fields

Re: List box to check fields