Qlik Community

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:

 

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 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: pie chart

like this ?

Untitled.png

10 Replies
shraddha_g
Honored Contributor III

Re: pie chart

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

briancopple
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?

arulsettu
Honored Contributor III

Re: pie chart

like this ?

Untitled.png

shraddha_g
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
arulsettu
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

LieferdatumBefuellt_Datum
20.12.2016 00:00:0020.12.2016 10:12.2016
16.12.2016 00:00:0018.12.2016 15:12.2016
14.12.2016 00:00:0014.12.2016 10:12.2016
12.12.2016 00:00:0012.12.2016 10:12.2016
10.12.2016 00:00:0011.12.2016 10:12.2016
08.12.2016 00:00:0009.12.2016 10:12.2016
05.12.2016 00:00:0005.12.2016 10:12.2016
03.12.2016 00:00:0003.12.2016 10:12.2016
30.11.2016 00:00:0030.11.2016 10:12.2016

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

arulsettu
Honored Contributor III

Re: pie chart

in script try this

date(floor(Lieferdatum)) as Lieferdatum,

date(floor(Befuellt_Datum)) as Befuellt_Datum

then try

Community Browser