Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Qrishna
Master
Master

See attached.

let me know if thats what you wanted?>

View solution in original post

13 Replies
Qrishna
Master
Master

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
Author

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
Author

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
Master
Master

you have 5 list boxes.

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

Qrishna
Master
Master

Let me know the filters?

Not applicable
Author

Month, Year and Division

Qrishna
Master
Master

See attached.

let me know if thats what you wanted?>

Not applicable
Author

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
Master
Master

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