Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

10 Replies
shraddha_g
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
Author

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
Author

How can I create a flag?

arulsettu
Master III
Master III

like this ?

Untitled.png

shraddha_g
Partner - Master III
Partner - Master III

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

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

Not applicable
Author

yes like this

arulsettu
Master III
Master III

create a calculated dimension in pie chart

If (Lieferdatum >= Befuellt_Datum,'okay',

If (Lieferdatum < Befuellt_Datum,'wrong'))

then use some measure

Not applicable
Author

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
Master III
Master III

in script try this

date(floor(Lieferdatum)) as Lieferdatum,

date(floor(Befuellt_Datum)) as Befuellt_Datum

then try