Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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