Straight Table Question

[#1]

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?

[Qrishna]

Hi prashant,

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

Post your demo application.

[#3]

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

[#4]

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

[Qrishna]

you have 5 list boxes.

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

[Qrishna]

Let me know the filters?

[#7]

Month, Year and Division

[Qrishna · Accepted solution]

See attached.

let me know if thats what you wanted?>

[#9]

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

[Qrishna]

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