topic Rolled up numbers in a table and filtering in QlikView

Rolled up numbers in a table and filtering

Fri, 11 Sep 2015 22:47:56 GMT

Hi,

I have requirement where I have data like below:

Name	Test1	Test2	Test3
ABC	On site	Off site	Both
XYZ	Off site	Both	On site
DEF	On site	Off site	On site
PQR	On site	Both	Off site

and I have to create a chart that shows the rolled up numbers like

	Test1	Test2	Test3
On site	3	0	2
Off site	1	2	1
Both	0	2	1

I was able to create similar looking chart using ValueList but the problem is I am not able to filter by selecting the values within the table.

The requirement is the user should be able to click on the values within the table and filter should be applied accordingly. For example, if the user clicks on value 3 in the above table, the filter should be applied on name field. In this case, Name should be filtered as ABC, DEF & PQR because these are the three names that has On Site value associated to Test1.

Attaching a sample qvw. Please let me know if something is not clear. Any help on this would be greatly appreciated.

Thanks!

Re: Rolled up numbers in a table and filtering

robert_mika — Sat, 12 Sep 2015 04:09:05 GMT

This may not solved all your problems but try:

Change to Pivot table

Add Name dimension to the right of the Valuelist.

You can filter down when you expand the second dimension

Re: Rolled up numbers in a table and filtering

Anonymous — Sat, 12 Sep 2015 13:53:08 GMT

If you use crosstable in the load script, the solution on the front end is trivial. See attached.

Re: Rolled up numbers in a table and filtering

Mon, 14 Sep 2015 00:32:48 GMT

Hi Michael,

I was able to change my data model with crosstable for this data and was able to achieve it. Thanks a lot for your help.

Thanks,

Malai

Re: Rolled up numbers in a table and filtering

Mon, 14 Sep 2015 00:35:34 GMT

Robert - It was helpful. If there were no other option I would have gone with this but Michael's suggestion below worked to satisfy my requirement completely. Greatly appreciate your help on this.

Thanks,

Malai