Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table dimension problem

Hi,

I have a table which contains one dimension: [Nickname]&[Mode].

Now I have an issue that when I open the page, I automatically set the month to the current running month. Now this filters out some of the dimensions, because they might not have data yet for the current month. How can I make the table not care about the month selection and always display all the available [Nickname]&[Model] dimensions? Thanks in advance.

// Tuomas

4 Replies
jaumecf23
Creator III
Creator III

Hi,

If your table has an Expression for example that sums the amount. You need to do something like this:

= sum ({<Month>}Amount)

Basically introduce the fields that you don't want to consider in the Set Analysis.

Anonymous
Not applicable
Author

I dont have any measures in the table, only one dimension. It sort of should work like a filter pane, but the filter pane includes the "gray" selections also which I dont like at all, thats why im kind of trying to do a table that works like a filter pane

jaumecf23
Creator III
Creator III

Are you using a Table box?

Anonymous
Not applicable
Author

I'm using a normal table.

// T