Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

suman_dhar
Contributor

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.

Tags (1)
1 Solution

Accepted Solutions

Re: Display data of any default project

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

10 Replies

Re: Display data of any default project

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

suman_dhar
Contributor

Re: Display data of any default project

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

Re: Display data of any default project

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

suman_dhar
Contributor

Re: Display data of any default project

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

Re: Display data of any default project

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

Re: Display data of any default project

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)

suman_dhar
Contributor

Re: Display data of any default project

default A is fine

suman_dhar
Contributor

Re: Display data of any default project

Or default select may be alws first one

Re: Display data of any default project

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

Community Browser