topic Re: Display data of any default project in QlikView

Display data of any default project

Anonymous — Sat, 14 Nov 2015 13:28:23 GMT

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.

Re: Display data of any default project

sunny_talwar — Sat, 14 Nov 2015 13:37:18 GMT

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

Re: Display data of any default project

Anonymous — Sat, 14 Nov 2015 17:32:54 GMT

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

Re: Display data of any default project

sunny_talwar — Sat, 14 Nov 2015 17:34:03 GMT

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

Re: Display data of any default project

Anonymous — Sat, 14 Nov 2015 17:49:46 GMT

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

Re: Display data of any default project

sunny_talwar — Sat, 14 Nov 2015 17:51:21 GMT

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

Re: Display data of any default project

settu_periasamy — Sat, 14 Nov 2015 17:53:22 GMT

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)

Re: Display data of any default project

Anonymous — Sat, 14 Nov 2015 18:09:50 GMT

default A is fine

Re: Display data of any default project

Anonymous — Sat, 14 Nov 2015 18:11:19 GMT

Or default select may be alws first one

Re: Display data of any default project

sunny_talwar — Sat, 14 Nov 2015 18:21:12 GMT

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

Re: Display data of any default project

Anonymous — Sun, 15 Nov 2015 05:04:02 GMT

Thank for your help.