topic Re: Conditioning for Chart Straight table object in QlikView

Conditioning for Chart Straight table object

Wed, 12 Oct 2016 14:33:27 GMT

I'm using Chart - Straight table object and getting data from QVX file. Current file having around 2 million records and sometimes getting Out of Memory because of this huge data. I was trying to apply conditional to this straight table and not getting output as expected.

Requirement:

If QVX data > 75000 records, get popup message and should give warning to Enduser and ask them to use one of the selection.

How do I can get this specific condition?

Ex: I defined like as below

Defined variable as vMaxData = 75000

Condition for Chart: If(Count(PROGRAM) < vMaxData,vMaxData)

Re: Conditioning for Chart Straight table object

rupamjyotidas — Wed, 12 Oct 2016 17:45:43 GMT

Use a Text Box on top the Straight Table, Remove the Text Box when your QVX data < 75000

You can define the conditions on layout section of the text box

Re: Conditioning for Chart Straight table object

maxgro — Wed, 12 Oct 2016 17:54:56 GMT

maybe with a GetPossibleCount(yourfield) <= 75000

and replace the "Calculation condition unfulfilled" in Error Messages with your message

Re: Conditioning for Chart Straight table object

Wed, 12 Oct 2016 19:07:45 GMT

Thanks, it is working