Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display data of any default project

Hi,

Please find the attached QVW and xls file.

In the application left hand side i want to show project wise name and its status. Rigt hand side chart contains project details.

Here all are working fine but....

In the left chart I want to display all the project name and its status and right hand side data will be displayed one project. If I click on the next project(left side chart) then the corrosponding data will be displayed on the right chart.

Rigt side chart will display data of any default project.

1 Solution

Accepted Solutions
sunny_talwar

Something like this?

Capture.PNG

Left hand chart can use this expression based on the requirement

Not to be impacted by any selections

If(Only({1} [Project Status])='Green','qmem://<bundled>/BuiltIn/led_g.png',

  If(Only({1} [Project Status])='Red','qmem://<bundled>/BuiltIn/led_r.png',

    If(Only({1} [Project Status])='Yellow','qmem://<bundled>/BuiltIn/led_y.png',

      'qmem://<bundled>/BuiltIn/led.png')))

Not to be impacted by selection in olny Project Name field

If(Only({<[Project Name]>} [Project Status])='Green','qmem://<bundled>/BuiltIn/led_g.png',

  If(Only({<[Project Name]>} [Project Status])='Red','qmem://<bundled>/BuiltIn/led_r.png',

    If(Only({<[Project Name]>} [Project Status])='Yellow','qmem://<bundled>/BuiltIn/led_y.png',

      'qmem://<bundled>/BuiltIn/led.png')))

View solution in original post

10 Replies
sunny_talwar

Something like this?

Capture.PNG

Left hand chart can use this expression based on the requirement

Not to be impacted by any selections

If(Only({1} [Project Status])='Green','qmem://<bundled>/BuiltIn/led_g.png',

  If(Only({1} [Project Status])='Red','qmem://<bundled>/BuiltIn/led_r.png',

    If(Only({1} [Project Status])='Yellow','qmem://<bundled>/BuiltIn/led_y.png',

      'qmem://<bundled>/BuiltIn/led.png')))

Not to be impacted by selection in olny Project Name field

If(Only({<[Project Name]>} [Project Status])='Green','qmem://<bundled>/BuiltIn/led_g.png',

  If(Only({<[Project Name]>} [Project Status])='Red','qmem://<bundled>/BuiltIn/led_r.png',

    If(Only({<[Project Name]>} [Project Status])='Yellow','qmem://<bundled>/BuiltIn/led_y.png',

      'qmem://<bundled>/BuiltIn/led.png')))

Anonymous
Not applicable
Author

If I clear the screen then all the records(for all project) are displaying again

sunny_talwar

So what are you expecting to see when you clear the screen???

Anonymous
Not applicable
Author

If you clear then also rigt side chart will display data of any default project.

sunny_talwar

Which project would you want to see? A or B??? What would be the logic here?

settu_periasamy
Master III
Master III

Hi,

May be like this..

Create one List Box -> Project

Select One Value , Then Property -> Always One Selected Value..

Then, Remove your List Box (if you don't want to display in the Sheet)

Anonymous
Not applicable
Author

default A is fine

Anonymous
Not applicable
Author

Or default select may be alws first one

sunny_talwar

Try this expression for your right chart:

If(Only({<[Project Name] = {"$(=MinString([Project Name]))"}>}[Task Status])='NA','qmem://<bundled>/BuiltIn/led.png',

  If(Only({<[Project Name] = {"$(=MinString([Project Name]))"}>}[Task Status])='Red','qmem://<bundled>/BuiltIn/led_r.png',

    If(Only({<[Project Name] = {"$(=MinString([Project Name]))"}>}[Task Status])='Yellow','qmem://<bundled>/BuiltIn/led_y.png',

      'qmem://<bundled>/BuiltIn/led_g.png')))