Display data of any default project

[Anonymous]

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.

[sunny_talwar · Accepted solution]

Something like this?

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]

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]

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]

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]

default A is fine

[Anonymous]

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')))