Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Do not pay attention to selection - in a Single Tablebox of a Worksheet

Hello community,

 

I have a QlikView report. In one of my worksheets, I want to have a table box that shows all the months, even though I have selected a month.

 

Unfortunately, I do not have a meaningful function to ignore this month selection in this table ...

 

 

Maybe one of you has a good idea

 

2 Replies
Highlighted
Not applicable

Hello Jan,

...use set anlaysis...

Maybe like...

          sum (  {< Monat = >}  Your_Value )

Your DBA 😉

Highlighted

You will not be able to use a set expression as there are no expressions in a table box. One option (and probably not the best one) is to use an alternate state.

But I suspect that you mean a straight table or pivot table, in which case you can add a selection override in a set expression. You will need to override whatever fields where the user might make selections. Something like

=Sum({<......., Monat>} .....)

or

=Sum({<......., Monat, Jahr, Quartal>} .....)  to override the selections in all three fields.

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