Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditioning for Chart Straight table object

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)

3 Replies
rupamjyotidas
Specialist
Specialist

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

maxgro
MVP
MVP

maybe with a  GetPossibleCount(yourfield) <= 75000 

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

1.png

Not applicable
Author

Thanks, it is working