Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

anjeepvr
Contributor II

How to suppress the dimensions values for which measure is null

HI,

I have two dimensions dim1  and dim2 in pivot table.

where dim2 are part of dim1 now i pivoted dim1

now my measure is avg(rating).

when i select any employee ,it should display only those dimension values what he know ,i want to suppress others which he dont know.

it should display only those where measure is not null.

gh.JPG.jpg

i want to suppress those marked with red fields.

can anyone please help me

Thanks,

ANjee

Tags (1)
2 Replies
Not applicable

Re: How to suppress the dimensions values for which measure is null

Not sure if I understand you correctly.

But you can try checking the option "Supress When Value is Null" in dimensions tab and "Supress Zero Values" or "Supress Missing" in presentation tab.

Hope this helps, if not please share your sample app.

anjeepvr
Contributor II

Re: Re: How to suppress the dimensions values for which measure is null

As i posted an image i want only those competency names which are not null

Community Browser