Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Is there a way to avoid selecting with the values populated in the dimension

Hi Guys,

I am trying to build a bar chart with two dimensions (Date and organisation). Is there a way that I can show the organisation but restrict selections for the organisation.

Thanks in advance.

Regards,

Varun Reddy. K

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Is there a way to avoid selecting with the values populated in the dimension

You can change the chart to read-only on general tab of chart properties.

User won't be able to select dimension values within the chart then (also no selection of dates).

View solution in original post

5 Replies
Highlighted

Re: Is there a way to avoid selecting with the values populated in the dimension

If for example organization is composed by A,B,C and D values and you do not want to show B then write in the

"calculated dimension"

If(Organization = 'B', Null(), Organization)

then check the box "Suppress when value is null"

let me know

Highlighted
MVP
MVP

Re: Is there a way to avoid selecting with the values populated in the dimension

I don't really understand your question. Do you want to see all organisations on the chart regardless of organisation selections? Then use a set expression like

     Sum({<organisation=>} Amount)

Otherwise, I suggest you upload your qvw or a representative sample to explain your question more clearly.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Re: Is there a way to avoid selecting with the values populated in the dimension

within your expression just add this as a set analysis:

{<Organisation = >}

Highlighted
MVP
MVP

Re: Is there a way to avoid selecting with the values populated in the dimension

You can change the chart to read-only on general tab of chart properties.

User won't be able to select dimension values within the chart then (also no selection of dates).

View solution in original post

Highlighted
Creator III
Creator III

Re: Is there a way to avoid selecting with the values populated in the dimension

Swuehl,

Is there a way to select Dates and restrict Organisation?

Regards,

Varun