Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

How to display selected record as first in charts?

Dear Experts ,


In my chart i am displaying country wise report . whatever be a country selection , i want to display all country record . so i am using set analysis  and making country value as null ({<Country=>})  .

But in my chart my first country details should be a  selected country in a country list box .   for ex my country list box value is dubai , then i want to display dubai country details as first record , rest will display next to dubai country details .

1 Solution

Accepted Solutions
Highlighted

Re: How to display selected record as first in charts?

See the attached file to see if this meets your requirement:

When UK is selected -> it is at the top

Capture.PNG

When USA is selected -> it is at the top

Capture.PNG

When Dubai is selected -> it is at the top

Capture.PNG

Used the following sort order -> =Match(Country, $(vVar))

Where vVar is equal to =Chr(39) &Country & Chr(39)

Capture.PNG

Capture.PNG

HTH

Best,

Sunny

View solution in original post

2 Replies
Highlighted
krishna20
Valued Contributor II

Re: How to display selected record as first in charts?

Hi,

Try this,

Goto Properties of your chart-> sort-> Choose Expression-> COMP_CODE=003(Dubai Company Code).

Highlighted

Re: How to display selected record as first in charts?

See the attached file to see if this meets your requirement:

When UK is selected -> it is at the top

Capture.PNG

When USA is selected -> it is at the top

Capture.PNG

When Dubai is selected -> it is at the top

Capture.PNG

Used the following sort order -> =Match(Country, $(vVar))

Where vVar is equal to =Chr(39) &Country & Chr(39)

Capture.PNG

Capture.PNG

HTH

Best,

Sunny

View solution in original post