Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

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..

Tags (1)
1 Solution

Accepted Solutions
danieloberbilli
Valued Contributor II

Re: how the restric the month level data in pivot table

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

1 Reply
danieloberbilli
Valued Contributor II

Re: how the restric the month level data in pivot table

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

Community Browser