Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolled up numbers in a table and filtering

Hi,

I have requirement where I have data like below:

 

NameTest1Test2Test3
ABCOn siteOff siteBoth
XYZOff siteBothOn site
DEFOn siteOff siteOn site
PQROn siteBothOff site

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

 

Test1Test2Test3
On site3 02
Off site121
Both 021

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!

1 Solution

Accepted Solutions
Champion III
Champion III

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

View solution in original post

4 Replies

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

Champion III
Champion III

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

View solution in original post

Not applicable

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

Not applicable

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