Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to ignore date selection on a table

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

1 Solution

Accepted Solutions
sunny_talwar

May be try this as your dimension and see if this works

Aggr(Only({1} Nickname & Mode), Nickname, Mode)

View solution in original post

1 Reply
sunny_talwar

May be try this as your dimension and see if this works

Aggr(Only({1} Nickname & Mode), Nickname, Mode)