Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

How to ignore the current selection when do set analysis? routine method doesn't work

Hello

I am a new qlik user and I found that routine method doesn't work on my qlik11.

Environment: tutorial.qvw, Sales sheet.

task: set the sales in 2005 as the reference: expression-- Sum ( {1<Year={2005}>} Sales)

issue:

The reference (2005) only presents well when you click the 2005 in Year list box. The rest selections are not good, even after you select all. I also attached the qvw file for reference.

Actually, what I want to do is to set 2005 as the baseline and compare the results of current selection to baseline. I will highly appreciate it if anyone can help me! Thanks a lot!

qlik01.jpg

qlik02_selections.jpg

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to ignore the current selection when do set analysis? routine method doesn't work

Hi,

     Its because of the dimension limit which you had set.

     Kindly remove that and see the basic functionality works properly.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to ignore the current selection when do set analysis? routine method doesn't work

Hi,

     Its because of the dimension limit which you had set.

     Kindly remove that and see the basic functionality works properly.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
Partner
Partner

Re: How to ignore the current selection when do set analysis? routine method doesn't work

Hi,

Kaushik Solanki is right. Besides you'll have to decide which sort to use. Probably the best sort order would be using an expression like sum({1<Year={2005}>} Sales), so you can see first the amounts for 2005 compared to any other year. So even if you have nothing selected, you'll stil see the countries with sales in 2005 first,

regards,

Highlighted
Not applicable

Re: How to ignore the current selection when do set analysis? routine method doesn't work

Thanks a lot! You have a nice week!

Highlighted
Not applicable

Re: How to ignore the current selection when do set analysis? routine method doesn't work

Kaushik's answer is corrent. But your answer is more detailed and it is the one helps me to understand why I can't see 2005!  Million thanks!