topic Re: how to display listboxes using with button object? in QlikView

how to display listboxes using with button object?

Fri, 30 Jan 2015 16:59:09 GMT

hi.

I created 2 listboxes in qlikview.that are 1.productid listbox and 2.dateupdate listbox. and create 2 buttons for each listbox.I use variable for one button object like this vshowhideobject i use expression like this if(vshowhide=1,0,1) after i apply variable in list box layout tab in conditional like this vshowhide=1.I applied same method in another listbox using button in qlikview. if i select product button then display productid listbox .ok it working well.but the problem is second button if i select date button then display only date listbox but it displayed 2 listboxes .I want display listboxes like this.If i select product button then display only productlistbox.if i select date button then display only date listbox.but when i select date button it display two objects.I want display listboxsas per button selections.I do not know how to finish this task.can you help me pls.

1. it is working .

2.I want display like this.

3.the problem is when i select date button it display 2 listboxes like this.

4.I want display like this if i select product button then display only productidl istbox.and if i select date button then display date listbox.how to display like this .can anyone help to me ? pls.

Thankyou

Regards

madhu

Re: how to display listboxes using with button object?

Gysbert_Wassenaar — Fri, 30 Jan 2015 18:23:01 GMT

If you want the buttons to act independently of each other then you'll have to use separate variables. If you use the same variable for both listboxes then both listboxes will respond to both buttons.

Re: how to display listboxes using with button object?

prieper — Fri, 30 Jan 2015 19:13:41 GMT

When putting one variable to 1, sametime add to put the other to 0

HTH Peter

Re: how to display listboxes using with button object?

Gysbert_Wassenaar — Fri, 30 Jan 2015 19:18:51 GMT

That scenario would not need two variables. You'd set one listbox to use =vshowhide as conditional display expression and the other to use =NOT vshowhide.

Re: how to display listboxes using with button object?

saurabh5 — Fri, 30 Jan 2015 19:28:11 GMT

if you want only 1 list box at a given instance create a 2 variables vproduct and vdate and give value as 1 or 0 in actions for the two button respectively and opposite values in the list boxes it will work as hide and show kind of feature.

Re: how to display listboxes using with button object?

Sat, 31 Jan 2015 04:04:44 GMT

hello gysbert.I use variable like this vshowhide and wrote conditional like this if(vshowhide=2,0,2) for date button.another prooductid button variable vshowhide =conditional =if(vshowhide=2,1,2).

i don 't know how to write variables . can explain with examples gybert pls

thankyou

Regards

madhu

Re: how to display listboxes using with button object?

sujeetsingh — Sat, 31 Jan 2015 04:08:14 GMT

Reddy,

Just go to reference document and study about the variables.

Well you can create the variables in Qlikview by these threads

Creating variables in qlikview

how to set variable???

Re: how to display listboxes using with button object?

PrashantSangle — Sat, 31 Jan 2015 04:11:58 GMT

Hi,

On Button Click You Setting variable value

on click of Product Button

are setting vshowhide=1

on click of Date Button

are setting vshowhide=2

Then on Conditional of list box write

for product id listbox

if(vshowhide=1,0,1)

for Date list box

if(vshowhide=2,0,1)

0 and 1 represent true/false value.

Regards

Re: how to display listboxes using with button object?

prieper — Sat, 31 Jan 2015 08:09:33 GMT

When working with alternate view/show you may also trigger like

vshowhide = NOT(vshowhide)

This will always toggle betw true and false provided there is a value set in the beginning (or in the script)

HTH Peter

Re: how to display listboxes using with button object?

Sat, 31 Jan 2015 14:13:56 GMT

Hi Madhu,

You can create variable in Settings --> Variable Overview by clicking 'Add' button.

Then you need to give condition in Layout tab as $(vShowhide)=1 for Product listbox and $(vShowhide)=2 for dateupdate.Then you can take two buttons and in actions you can take Set Variable and for Products Button give $(vShowhide)=1 and for dateupdate give $(vShowhide)=2. That's it!

Please find attached QVW.

Thanks,

Chiru