# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## pie chart

Hello together,

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

 Lieferdatum Befuellt_Datum 20.12.2016 20.12.2016 16.12.2016 18.12.2016 14.12.2016 14.12.2016 12.12.2016 12.12.2016 10.12.2016 11.12.2016 08.12.2016 09.12.2016 05.12.2016 05.12.2016 03.12.2016 03.12.2016 30.11.2016 30.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 Solution

Accepted Solutions
Honored Contributor III

## Re: pie chart

like this ?

10 Replies
Honored Contributor III

## Re: pie chart

Create those flags in script and then use that flag as dimension in Pie chart

Contributor II

## Re: pie chart

Hi Kevin

If all you want to see in your pie chart is the number or percentage that are "ok" or "wrong" in your load script create a new column by using If (Lieferdatum < Befuellt_Datum,'wrong','ok') as [new field] then use the [new field] as the dimension in your pie chart. I hope this is useful but if I've misunderstood your question please can you provide more information.

Kindest regards

Brian

Not applicable

## Re: pie chart

How can I create a flag?

Honored Contributor III

## Re: pie chart

like this ?

Honored Contributor III

## Re: pie chart

If (Lieferdatum >= Befuellt_Datum) , 'okay',

If (Lieferdatum < Befuellt_Datum) ,'wrong')) as Flag

Not applicable

## Re: pie chart

yes like this

Highlighted
Honored Contributor III

## Re: pie chart

create a calculated dimension in pie chart

If (Lieferdatum >= Befuellt_Datum,'okay',

If (Lieferdatum < Befuellt_Datum,'wrong'))

then use some measure

Not applicable

## Re: pie chart

Thank you.

maybe you can help me again.
In another Table I have the date type like DD.MM.YYYY hh:mm:ss

 Lieferdatum Befuellt_Datum 20.12.2016 00:00:00 20.12.2016 10:12.2016 16.12.2016 00:00:00 18.12.2016 15:12.2016 14.12.2016 00:00:00 14.12.2016 10:12.2016 12.12.2016 00:00:00 12.12.2016 10:12.2016 10.12.2016 00:00:00 11.12.2016 10:12.2016 08.12.2016 00:00:00 09.12.2016 10:12.2016 05.12.2016 00:00:00 05.12.2016 10:12.2016 03.12.2016 00:00:00 03.12.2016 10:12.2016 30.11.2016 00:00:00 30.11.2016 10:12.2016

Important is just the date not the time. How I can ignore the time?

Honored Contributor III

## Re: pie chart

in script try this

date(floor(Lieferdatum)) as Lieferdatum,

date(floor(Befuellt_Datum)) as Befuellt_Datum

then try