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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Don't automatically clear the selected conditions

   I use qv11,

  qv automatically clear the selected conditions ,for example:year(choose 2001),yearmonth(choose 200206,200207),qv will clear year field.

  I don't want to automatically clear the selected conditions .

  I can't find a way to set it ,

  Are there any other methods?

  thanks!

5 Replies
Not applicable
Author

Hi,

In qlikview if you select new value which are contradict to previous selection then QV automatically clears previous contradict selections and makes new selection.

It is feature of QV.

and when you are  seelcting 2002 year months, then there is no sense of having year 2001 selected.

Hope it helps you.

Niranjan M.

Not applicable
Author

Thanks for your reply.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The default behavior is that new selections will remove incompatible previous selections. You can override this by using Lock. Lock the Year field after selecting 2001 and then selections in other Year-Months will not override.

-Rob

Not applicable
Author

hi Rob Wunderlich

Thanks for your reply.

pivot (dimention-year,port;expression-amount

Current Selections:

1.JPG

data:

2.JPG

no data

How to appear in the pivot.

thanks!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

1. Create a pivot table.

2. Add Dimensions Year, Port.

3. Add Expression =sum(Amount)

-Rob