Skip to main content

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how the restric the month level data in pivot table

Hi friend.

I have a requirement here..

I have to do one dashboard some thing like this...

we have hierarchy data stored in the pivot table, (year>month>week)

when ever I have to clik the month in wise data , week data should n't be showed and my table display only month data.

how can I do that..

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

Please find an example attached. I assumed that you have Listboxes with Year, Month and Week values. When you select a value in Month, the Week column should be hidden, right?

I solved this using Enable Conditional for Dimensions:

Capture.PNG.png

View solution in original post

1 Reply
danieloberbilli
Specialist II
Specialist II

Please find an example attached. I assumed that you have Listboxes with Year, Month and Week values. When you select a value in Month, the Week column should be hidden, right?

I solved this using Enable Conditional for Dimensions:

Capture.PNG.png