Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Straight Table Question

Hi Guyz,

I am new to QlikView and completely stuck at a point.

I have a straight table and around 3 list boxes. Normally Table gets updated as soon as we select a item in list box, But my requirement is Table should not get updated till we select all the filters. It should be updated only after selecting all the filters and upon clicking on "Go" button. Till then straight table should not display any data.

How can I do this?

1 Solution

Accepted Solutions
krishna_2644
Valued Contributor III

Re: Straight Table Question

See attached.

let me know if thats what you wanted?>

12 Replies
krishna_2644
Valued Contributor III

Re: Straight Table Question

Hi prashant,

For sure we can achieve this by using variables and applying some conditions in the table chart.

Post your demo application.

Not applicable

Re: Straight Table Question

Hi Chaitanya,

Please find the attachment for the data sheet and the QVW file. I have some list boxes and a Straight table in the file.

Let me know if anything else needed.

Thanks for your help,

Prasant Tata

Not applicable

Re: Straight Table Question

Also I am trying to do this with the concept of "Alternate States" which I found in another community. For some reason it didn't work out for this app. Can you please also throw some light on this?

Thanks,

Prasant Tata

krishna_2644
Valued Contributor III

Re: Straight Table Question

you have 5 list boxes.

what are the 3 list boxes which are acting as filters?

krishna_2644
Valued Contributor III

Re: Straight Table Question

Let me know the filters?

Not applicable

Re: Straight Table Question

Month, Year and Division

krishna_2644
Valued Contributor III

Re: Straight Table Question

See attached.

let me know if thats what you wanted?>

Not applicable

Re: Straight Table Question

Hey,

That completely works for the requirement... Can you please explain me where I went wrong. I have created Alternate States but that didn't work, DO I need to perform something other than creating those states. Please Let me know.

Thanks for your help,

Prasant Tata

krishna_2644
Valued Contributor III

Re: Straight Table Question

You have set a variable which only has value when all the filters have been selected.

Thats what

=if(GetSelectedCount(Year)>=1 and GetSelectedCount(Quarter)>=1 and GetSelectedCount(Month)>=1,'Go',0)

means.

on the chart, you have to specify calculation condition.

i.e on general tabl of chart    vGo = 'Go' means