topic Re: Display the values for 1 listbox in QlikView

Display the values for 1 listbox

Tue, 21 Jan 2014 06:47:30 GMT

Hi All,

I have 2 listboxes(Listbox-a,List box-b) and 1 pivot table, in my pivot table when i select listbox-a it is showing the value correctly.

But when i select Listbox-a and listbox-b it is showing the value zero.

Because there is no relation between these two list boxes and there is no values for listbox-b.

If i will select listbox-a and listbox-b in my dashboard, i want to show the values for listbox-a in my pivot table.

can anyone help me...

Regards,

baru

tresB — Tue, 21 Jan 2014 06:55:57 GMT

Without your sample app, it would be long thread only keeping you asking many questions. Please attach your sample app.

Tue, 21 Jan 2014 07:03:30 GMT

In your pivot table, use set analysis in your expressions and ignore the selection done at Listbox-b.

sum({<Listbox-a-Field={'TestData'},Listbox-b-Field=>}Sales)

where Listbox-a-Field is the field used to populate Listbox-a

where Listbox-b-Field is the field used to populate Listbox-b

Thanks,

Angad