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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

100% of the Data

Hi Community,

PFA,

i want to show 100% of data..

7 Replies
Anonymous
Not applicable
Author

Sunil

Did you mean to attach something ?

Also could you expand on your question, it is more than a little vague.

Best Regards,     Bill

Not applicable
Author

Hi Sunil,

Elaborate little briefly question, we are not find any attachment here.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

In any expression you can ignore any selections and show the totals for the entire data set using Set Analysis.  The prefix '1' can be used to specify the whole set, and it can be used on it's own without any qualifier, so you could have this as an expression:

sum({1}Value)

As well as giving you a total value, regardless of selections this will also cause all dimensions to show.

You need to ensure you make users aware that the expression isn't based on the selection - perhaps by means of a text box explaining this.

Hope that answers your question - if not please elaborate on what your question was.

- Steve

swuehl
MVP
MVP

Seems like you've deleted some posts and the responses attached, which is not a good idea, since it breaks the history of a discussion and confuses not only the ones that already took part.

I am reattaching the modified document. I haven't understood your latest comments (now deleted 😞 ), so if there are any open issues, please repost.

swuehl
MVP
MVP

Again, lot of posts seem to get deleted from this thread.

Whoever is responsible for that, please don't do it!

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

I've just realised that where I have been sending responses via email to

deleted posts these have just been ditched by Jive. Intensely frustrating.

-Steve

Not applicable
Author

Sorry for that.

Really i don't know what happend