Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelaa_123
Contributor II
Contributor II

alert about no data after days in the text box

Hi,

I need create text box, where I have information, which days we have no sale. I need it to verify the correctness of the data.

Example:

We have tables with 3 columns: date, sale and flag (1- sale, 0 - no sale). I tried to write a text box via the if function.

Expected result in textbox: no data: 2022-05-03, 2022-05-05, 2022-05-08

Data Sales Flag
2022-05-01 5647,0 1
2022-05-02 736464,0 1
2022-05-03 0,0 0
2022-05-04 7564,0 1
2022-05-05 0,0 0
2022-05-06 4264746,0 1
2022-05-07 6743,0 1
2022-05-08 0,0 0

 

thank you for any advice 🙂

Labels (1)
1 Solution

Accepted Solutions
antose
Partner - Creator II
Partner - Creator II

Hi! Try this

='There is '&Count({$<Flag = {0} > } Data)&' days with no sales:'&Chr(10)&Chr(10)&Concat({$<Flag = {0} > } Data, ', ')

antose_0-1653920358498.png

 

View solution in original post

2 Replies
antose
Partner - Creator II
Partner - Creator II

Hi! Try this

='There is '&Count({$<Flag = {0} > } Data)&' days with no sales:'&Chr(10)&Chr(10)&Concat({$<Flag = {0} > } Data, ', ')

antose_0-1653920358498.png