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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-12-20 05:54 AM

pie chart

Hello together,

i have a question about the pie chart. I have the table with the dates:

 

LieferdatumBefuellt_Datum
20.12.201620.12.2016
16.12.201618.12.2016
14.12.201614.12.2016
12.12.201612.12.2016
10.12.201611.12.2016
08.12.201609.12.2016
05.12.201605.12.2016
03.12.201603.12.2016
30.11.201630.11.2016

Now I wanted to show

If (Lieferdatum = Befuellt_Datum) than "okay"

If (Lieferdatum > Befuellt_Datum) than "okay"

If (Lieferdatum < Befuellt_Datum) than "wrong"

and this integrated in a pie chart. How is that possible?

1,796 Views
0 Likes
10 Replies
Not applicable
‎2016-12-20 06:49 AM
Author

In response to

While loading you can

If (date(Lieferdatum,'DD.MM.YYYY') >= date(Befuellt_Datum,,'DD.MM.YYYY'),'okay',

If (date(Lieferdatum,,'DD.MM.YYYY') < date(Befuellt_Datum,''DD.MM.YYYY'),'wrong'))

200 Views
0 Likes