Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

HEADING IN CHARTS

Dear All

I have charts & Pivote table which are working fine , but now i have to add a heading Sales Order  Date From xxxx  To xxxx

I have only one field order date.

Please let me know any trick to show this even Order date is not in selection .

means by using possibly selected view ,  min and max

Regards

Pramod Kumar

7 Replies
Highlighted
Partner
Partner

your header should be

='Sales Order  Date From ' & date(min(order date)) &  ' To ' & date(max(order date))

Highlighted
Partner
Partner

Hi Pramod,

Your question is not very clear. You can use  two variable VMinDate =Min(SalesOrderDate) and vMaxDate=Max(SalesOrderDate) and use them in heading. Hope this will work for you

Vijay

Highlighted
Not applicable

Vijay , In pivote tabels , we have row which consist of name fields.

can we add one super heading "Sales order details From $vMindate To $vMaxdate)

Regards

Pramod Kumar

Highlighted
Partner
Partner

Can you please provide sample . 

Highlighted
Not applicable

Dear Vijay

This is the Sample file . Please get that

Regards

Pramod Kumar

Highlighted
Partner
Partner

No Attachement.. . I m using QV Personal edition so I cdnot be able to open your qv file. Can you please provide image of report you want.

Highlighted
Champion
Champion

try this

='Sales order details From   '& date($(vDateMin) )&' To  '& date($(vDateMax))

hope this helps